Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 279,975 members
  • 7,273 online
  • 2,052,395 posts
  • 155,134 Solutions
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here

Welcome to Qlik Community

Recent Discussions

  • forum

    Installing and Upgrading

    Talend Data Managment Platform 8-0 with this features inclures building and publ...

    Hi,If the license have:Talend Data Managment Platform 8-0DI/ESB Named 0DI/ESB ConcurrentDQ Named 3DQ concurrentMDM Named 0MDM concurrentAU Named 3AU c... Show More

    Hi,

    If the license have:

    Talend Data Managment Platform 8-0
    DI/ESB Named 0
    DI/ESB Concurrent
    DQ Named 3
    DQ concurrent
    MDM Named 0
    MDM concurrent
    AU Named 3
    AU concurrent
    DP Named 3
    DS Named 3
    Runtime Open
    Talend Cloud check

    We can build routes, services and install talend runtime?

    thanks

    Show Less
  • forum

    App Development

    Hide Technical Dimension from Exported Excel While Retaining Table Logic

    I have a Qlik table where a technical dimension (ProductDRSKey) is required for the current table logic and calculations. As a result, when users exp... Show More

    I have a Qlik table where a technical dimension (ProductDRSKey) is required for the current table logic and calculations. As a result, when users export/download the table data to Excel, this field is also included in the exported file.

    Our business users would prefer not to see this technical field in the Excel export because it is only used internally and adds unnecessary data to the downloaded file.

    I investigated a few options, but since the field is used as a dimension for the existing implementation, removing or hiding it appears to affect the current logic.

    My question is: Is there any supported approach in Qlik Sense to:

    • Keep a dimension available for internal table logic
    • Prevent that dimension from appearing in exported/downloaded Excel data
    • Or hide/mask the column only in the export without impacting existing functionality

    Has anyone encountered a similar requirement or found a workaround?

    Show Less
  • forum

    App Development

    Table Titles Missing When Exporting Tabbed Container to Excel

    Hi Everyone,I have 3 tables inside a Tabbed Container in Qlik Sense.When I export the container to Excel, all 3 tables are exported into separate shee... Show More

    Hi Everyone,

    I have 3 tables inside a Tabbed Container in Qlik Sense.

    When I export the container to Excel, all 3 tables are exported into separate sheets. However, the table titles are missing in the Excel export.

    Is there any way to include the table titles in the Excel export, either at the top of each sheet or as the sheet name?

    Any suggestions would be appreciated.

    Thanks!

     

    Show Less
  • forum

    Talend Cloud

    Erreurs aléatoires lors des appels REST header parser received no bytes

    Lors de l’exécution du job Talend MOODLE_INSCRIPTIONS_T010_J001, les appels REST vers Moodle échouent de manière aléatoire.Le même traitement peut fon... Show More

    Lors de l’exécution du job Talend MOODLE_INSCRIPTIONS_T010_J001, les appels REST vers Moodle échouent de manière aléatoire.
    Le même traitement peut fonctionner correctement après relance, mais planter plus tard sur un autre cas.

    Exemple d’erreur rencontrée :

    jakarta.ws.rs.ProcessingException: java.io.IOException: IOException invoking
    https://junia-learning.com/webservice/rest/server.php?...
    HTTP/1.1 header parser received no bytes
    Caused by: java.io.EOFException: EOF reached while reading


    Constatations :

    Le problème n’est pas systématique, il survient de façon aléatoire.

    Une relance du job permet de passer certains cas, mais d’autres échouent ensuite.

    L’erreur semble indiquer une coupure ou absence de réponse complète côté HTTP (EOF / header parser received no bytes).

    Impacts :

    Les inscriptions Moodle ne passent pas de manière fiable.

    Risque d’incohérences ou d’inscriptions incomplètes côté plateforme.

    Actions déjà testées :

    Relance du job → fonctionne temporairement mais pas de solution durable.

    Avez vous une solution a me proposer pour palier a ce problème ? 

    D'avance Merci 

    Show Less
  • forum

    Visualization and Usability

    OIDC logout flow in Qlik Sense Client Managed

    We configured an OIDC Virtual Proxy in Qlik Sense Client-Managed.Login works (although we needed to block additional claim) but qlik doesn't call the ... Show More

    We configured an OIDC Virtual Proxy in Qlik Sense Client-Managed.

    Login works (although we needed to block additional claim) but qlik doesn't call the logout flow in the OIDC provider.

    We are connecting to an institutional provider that requires logout to be handled in order to allow the service usage.

    It's not clear to us if this is not supported at all or we need to change configurations.

    Also, are there workarounds for this?

    thanks,

    Gianluca

    Show Less
  • forum

    Visualization and Usability

    Why does AGGR() return different results than direct aggregation for percentage ...

    Hi Experts,I have dataset looks like below table: There is another table having columns Region > Zone > Country. The problem I am facing is that in pi... Show More

    Hi Experts,

    I have dataset looks like below table:

    akmalquamri_0-1789997690571.png

     

    There is another table having columns Region > Zone > Country.

     

    The problem I am facing is that in pivot table I have hierarchy Region > Zone > Country > Shopkeeper. With this hierarchy, my below two codes were working fine

    Code1:

    Pick(Match(GetObjectDimension(Dimensionality()-1), 'Region', 'Zone', 'Country', 'Shopkeeper'),

    Sum(global shop distribution)/sum(Total <region> global shop distribution),

    Sum(global shop distribution)/sum(Total <zone> global shop distribution),

    Sum(global shop distribution)/sum(Total <country> global shop distribution),

    Sum(global shop distribution)/sum(Total <country> global shop distribution),)

     

    code2:

    Pick(Match(GetObjectDimension(Dimensionality()-1), 'Region', 'Zone', 'Country', 'Shopkeeper'),

    Sum(AGGR(Sum(global shop distribution)/sum(Total <Region> global shop distribution), Region, Zone, Country, Shopkeeper)),

    Sum(AGGR(Sum(global shop distribution)/sum(Total <Zone> global shop distribution), Region, Zone, Country, Shopkeeper)),

    Sum(AGGR(Sum(global shop distribution)/sum(Total <Country> global shop distribution), Region, Zone, Country, Shopkeeper)),

    Sum(AGGR(Sum(global shop distribution)/sum(Total <Country> global shop distribution), Region, Zone, Country, Shopkeeper))

    )

     

    As I change the hierarchy to shopkeeper > region > zone > country first code is running properly but second code is showing different answers.

    Code1:

    Pick(Match(GetObjectDimension(Dimensionality()-1), 'Shopkeeper', 'Region', 'Zone', 'Country'),

    Sum(global shop distribution)/sum(Total < Shopkeeper> global shop distribution),

    Sum(global shop distribution)/sum(Total <Region> global shop distribution),

    Sum(global shop distribution)/sum(Total <Zone> global shop distribution),

    Sum(global shop distribution)/sum(Total <Zone> global shop distribution))

     

    code2:

    Pick(Match(GetObjectDimension(Dimensionality()-1), 'Shopkeeper', 'Region', 'Zone', 'Country'),

    Sum(AGGR(Sum(global shop distribution)/sum(Total <Shopkeeper> global shop distribution), Region, Zone, Country, Shopkeeper)),

    Sum(AGGR(Sum(global shop distribution)/sum(Total <Region> global shop distribution), Region, Zone, Country, Shopkeeper)),

    Sum(AGGR(Sum(global shop distribution)/sum(Total <Zone> global shop distribution), Region, Zone, Country, Shopkeeper)),

    Sum(AGGR(Sum(global shop distribution)/sum(Total <Country> global shop distribution), Region, Zone, Country, Shopkeeper))

    )

    I need this because I want to get sum of these calculations at above level plus multiplying these with master item of another calculation. I want to fix this AGGR calculating then my problem will get resolve.

     

    If any suggestions of different approaches will be highly appreciated.

     

    Thanks for your attention.

    Show Less
  • forum

    Qlik NPrinting

    Upgrading Feb 2024 SR1 To Feb 2024 SR4

    Hi All,I've been trying to upgrade Nprinting Feb 2024 SR1 to SR4,  but in most of the after making all the recommended steps, I execute the installer ... Show More

    Hi All,

    I've been trying to upgrade Nprinting Feb 2024 SR1 to SR4,  but in most of the after making all the recommended steps, I execute the installer and instead of say "Upgrade" just says "Install".

    If I do the install, it creates a new instance of Nprinting along the current install, If I delete the previous version (SR1) and keep SR4, when I restore the repository and start the services, It requires me the licencing again, which I dont have (yet) and I thought it should be automatically.

    Please if anyone had the same issue or know what could be I'd really appreciate your help.

     

    Thanks

    Show Less
  • forum

    Installing and Upgrading

    Evaluation/trial license for Qlik Sense Enterprise on Windows?

    Hi all,Is there a supported way to get a time-limited trial / evaluation license for Qlik Sense Enterprise on Windows for testing purposes? I am just ... Show More

    Hi all,

    Is there a supported way to get a time-limited trial / evaluation license for Qlik Sense Enterprise on Windows for testing purposes? I am just looking to stand up a small test instance to evaluate the product before making any decisions.

    Any guidance on how to obtain a trial license would be greatly appreciated!

    Thanks

    Show Less
  • forum

    App Development

    How to add font to the list of fonts in Qlik Sense Styling properties

    Hi,  I am working with Qlik Sense February 2024 Patch 1 (QSEoW) and I am wondering what makes the list of fonts which we can choose from when styling ... Show More

    Hi, 

    I am working with Qlik Sense February 2024 Patch 1 (QSEoW) and I am wondering what makes the list of fonts which we can choose from when styling objects. The list opens up and presents various fonts but those are not all fonts this client has and uses. I would like to add my own font to that list so it is always present for users to choose from. Is there any documentation regarding custom font requirements and whether it is possible to add one to that list without creating custom theme?

    I am going through documentation trying to find anything on that subject but so far I didn't see anything.

    thanks

    Lech

    Lech_Miszkiewicz_0-1710891686578.png

     

     

    Show Less
  • forum

    Español

    Filtro de calendario para varias tablas con fecha desde y hasta

    Hola! Estoy en mis primeros meses de aprendizaje de qlik y me surge una duda a la hora de hacer un informe. La idea es crear una tabla que muestre el ... Show More

    Hola! Estoy en mis primeros meses de aprendizaje de qlik y me surge una duda a la hora de hacer un informe.

    La idea es crear una tabla que muestre el precio a pagar por cada uno de los socios de un gimnasio.

    El precio a pagar varía en función del producto contratado, pero todos los productos tienen una estructura común: Precio base, Descuento por forma de pago, Recargo por edad

    Cada uno de estos conceptos del desglose tiene una fecha desde y una fecha hasta, de forma que periódicamente los precios, descuentos y recargos varían, pero el informe nos podría mostrar el precio pagado por un socio a una fecha dada. 

    Con todo esto mi idea es tener las siguientes tablas:

    - Socios: IDSocio, IDProductoContratado, Edad, Forma de pago

    - Productos: IDProductoContratado, IDPrecio, IDRecargo, IDDescuento

    - Precio: IDPrecio, Precio, Fecha Desde, Fecha Hasta

    - Recargo: IDRecargo, Recargo, Fecha Desde, Fecha Hasta

    - Descuento: IDDescuento, Descuento, Fecha Desde, Fecha Hasta

    *Nota: Ahora mismo los precios, recargos y descuentos tienen una vigencia de 1 año, es decir, sus fechas de alta serán siempre 1 de Enero y la de baja 31 de diciembre, pero esto podría cambiar en un futuro.

     

    A la hora de crear el informe con la tabla y el filtro de calendario me surgen varias dudas:

    - ¿Como cargo los datos para evitar relaciones con fechas incompatibles? Es decir, si mi socio número 1 es alta desde 2021, la idea es mostrar 3 líneas para ese socio: 

    1. Año 2021: Con precio de 2021, Recargo de 2021 y Descuento de 2021
    2. Año 2022: Con precio de 2022, Recargo de 2022 y Descuento de 2022
    3. Año 2023: Con precio de 2023, Recargo de 2023 y Descuento de 2023

    Cualquier otra combinación de precios, recargos y descuentos sería inutil y solo ralentizaría la carga, así que debería evitarse

    - ¿Como creo un calendario que me permita seleccionar 1 día concreto y me muestre los precios a pagar por cada socio en ese dia? Tengo claro como crear una link table y una calendar que me permita hacer filtros de fecha seleccionando el tipo de fecha por el que deseo filtrar, pero desconozco como hacer un calendario que me filtre por los 3 conceptos al mismo tiempo y mas aun teniendo en cuenta que los conceptos tienen rangos de fecha.

     

    Perdón por el tocho, pero creía conveniente explicar detalladamente el problema.

    Espero que alguien me pueda ayudar.

     

    Un saludo!

    Show Less
Leaderboard

Qlik community MVPs

Qlik Community MVPs — trusted experts driving collaboration, learning, and innovation.

mvp-banner-side-image