Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 241,295 members
  • 4,606 online
  • 2,024,043 posts
  • 152,225 Solutions
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY

Welcome to Qlik Community

Recent Discussions

  • No Boards Found
  • forum

    App Development

    Subtotal by fields (maybe Aggr)

    I'm trying to get a % of "VRN Check" for each scenario. To do that I want a Count of Records by [Lock Local Period], [TDW Legal Entity Code] and [TDW ... Show More

    I'm trying to get a % of "VRN Check" for each scenario. To do that I want a Count of Records by [Lock Local Period], [TDW Legal Entity Code] and [TDW Amz Reg Jurisiction] only (exluding the [VRN Check] field) so I can divide the Count of Records by that. 

    So in the below example the new column should be the 1359 for Dec-2024 ACCI AB for both the first 2 rows.

    shane_spencer_1-1737387726226.png

     

     

    shane_spencer_0-1737387560141.png

     

    Show Less
  • forum

    Move to SaaS

    Cloud file share as a Data connection on QlikCloud

    Hi everyone @Michael_Tarallo  We're moving from QSEoW (client managed on AWS) to QlikCloud. We set up the migration tools and it is working fine. We h... Show More

    Hi everyone @Michael_Tarallo 

    We're moving from QSEoW (client managed on AWS) to QlikCloud.

    We set up the migration tools and it is working fine.

    We have a lot of "folder" data connections that uses FSX (an AWS  file sharing service for windows) that contains all the files used by the apps and I didn't find a way to map or to create a new dataconnection using a network path.

    What are the solutions available on QlikCloud for this scenario please ?

    On this video https://www.youtube.com/watch?v=sBsbdmmYWAE&t=2255s (chapter: Hybrid cloud environments and Cloud Storage) made by the Qlik-support they are saying that it is a feature that was planned for first or half 2024 for the data gateway tool. but I can't find infos on it..

    Thank you

    -Youssef

    Show Less
  • forum

    Qlik Application Automation

    Straigth table - colonne alternative - afficher la colonne si

    Bonjour à tous,   J'ai crée un graphique straight Table, dans laquelle j'ai ajouté une colonne alternative avec une mesure (Mnt). J'ai également une d... Show More

    Bonjour à tous,

     

    J'ai crée un graphique straight Table, dans laquelle j'ai ajouté une colonne alternative avec une mesure (Mnt).

    J'ai également une dimension produit. Et je voudrais que ma colonne alternative ne s'affiche dans l'explorateur graphique que si le produit 'PRODUIT1' est sélectionné, soit qu'il est le seul sélectionné soit que plusieurs produits sélectionné dont PRODUIT1.

    J'ai mis l'expression =If(Match(GetFieldSelections([Code produit gestion]), 'PRODUIT1'), 1, 0) dans le paramètre "Afficher la colonne si".

    Mais quand je sélectionne PRODUIT1, la colonne ne s'affiche pas dans la liste.

     

    J'ai fait le test en basculant la mesure dans la liste des colonnes qui s'affichent pas défaut et la condition fonctionne mais si le produit 1 est uniquement sélectionné.

    Est ce que vous avez une solution pour que çà marche en tant que colonne alternative ?

     

     

    Show Less
  • forum

    App Development

    To hide column of search bar in straight table

    Hi Qlik Community,   I have a straight table used in dashboard and as usual search bar is present for the dimensions used, but I have added a custom t... Show More

    Hi Qlik Community,

     

    I have a straight table used in dashboard and as usual search bar is present for the dimensions used, but I have added a custom theme which hides the search bar for tables and I can see it clearly hidden in dashboards but when I share the sheet as pdf through mail I observed the search bar column is still visible on the chart. Can I know why the custom theme is not applying on the sheet shared across?

    Thanks in advance for any help.

    Show Less
  • forum

    New to Qlik Analytics

    Pivot Table: Sort ascending/descending by expression and apply sorting to all di...

    Hello, I have a pivot table where i am trying to sort my columns (dimensions) either ascending or descending order dynamically. For this i have two bu... Show More

    Hello,

    I have a pivot table where i am trying to sort my columns (dimensions) either ascending or descending order dynamically. For this i have two buttons that return a boolean (vSort) : -1 if you click on descending or 1 if you click on ascending.  In my pivot table , in "Sorting" then I  "Sort by expression:" =if($(vSort) = 1, Count([Number]),-Count([Number]))  where Count([Number]) is my Measure in the pivot table.

     

    The problem is that the sorting only applies to the first dimension of the table and I am trying to apply it to all dimensions. Do you have an idea how to do it?

     

    Thanks.

    Show Less
  • forum

    App Development

    Pivot Table Selection

    Hi Qlik Community, I want to ask if there is a way to drill down a single level for all records when clicking the first level record. For example if w... Show More

    Hi Qlik Community,

    I want to ask if there is a way to drill down a single level for all records when clicking the first level record.

    For example if we have 2020 to 2024 as the pivot table dimension, if you click the plus for 2024 then all years would expand. The reason being this will save to time especially with some levels having a lot of records to drill down.

    I'm not sure this is possible but please let me know if there is a solution or a work around or maybe an extension to use. 

    Thanks in advance for any help

    Show Less
  • forum

    Qlik Application Automation

    Help Needed: Using Variables for Drive ID and Item ID in Qlik App Automation

    Hello everyone, I’m currently working on creating an automation using Qlik Application Automation. In this automation, I use Excel blocks, and in each... Show More

    Hello everyone,

    I’m currently working on creating an automation using Qlik Application Automation. In this automation, I use Excel blocks, and in each Excel block, there are two inputs: Drive ID and Item ID.

    Instead of manually entering these values every time, I’d like to create two variables: one for the Drive ID and another for the Item ID. However, I’m not sure how to make these variables point to the specific Drive ID and Item ID I need.

    Does anyone have advice or guidance on how to set this up?

    Thanks in advance!

    Show Less
  • forum

    New to Qlik Analytics

    Unmapped IDs Tagging

    Hi,  I have the following data: [Mappings]: *THIS TABLE SHOWS EVERY ID THAT HAS A TEAM MAPPING* LOAD [ID], [TEAM], from [MAPPING TABLE] [Table1]NoConc... Show More

    Hi, 

    I have the following data:

    [Mappings]: *THIS TABLE SHOWS EVERY ID THAT HAS A TEAM MAPPING*

    LOAD

    [ID],

    [TEAM],

    from [MAPPING TABLE]

    [Table1]
    NoConcatenate
    LOAD
    "Official ID" as [People ID]
    FROM [SHEET 1]

    [ID has link]:
    NoConcatenate
    LOAD
    [ID] as [Linked ID]
    resident [Mappings];

    Concatenate ([Mappings])

    LOAD
    [People ID] as [ID],
    'No Team' as [TEAM],
    'Unmapped ID' as [Responsibility]
    resident [Table1]
    where not exists ([Linked ID],[People ID]);


    Drop table [ID has link];
    Drop table [Table1];

     

    LOAD *THIS LOAD PULLS EVERY ID IN REGARDLESS OF A MAPPING AND TIES MORE INFO LIKE COUNTRY AND ID CODE ASSOCIATING TO THE MAPPING TABLE WITH [ID]*

    [Official ID] as [ID],

    [ID CODE],

    [COUNTRY]

    FROM [TABLE 2]

     

    THE QUESTION: every ID will be aligned to a unique [ID CODE] and multiple [ID] can belong to a [ID CODE]....i want to add another tagging similar to the above but for [ID CODE] to essentially see the [ID CODE] does not appear in the MAPPING TABLE....once the [ID] field is associated. 

    i keep getting a synthetic key....if someone could help that would be great!

     

    Show Less
  • forum

    Qlik Application Automation

    How to get Space -> Apps -> Sheets information into a QVD file using single Auto...

    I am trying to get the details of all the space, apps and the sheets in each app into a QVD file to create an app on this. Could anyone suggest how to... Show More

    I am trying to get the details of all the space, apps and the sheets in each app into a QVD file to create an app on this. Could anyone suggest how to achieve this in Qlik Sense SaaS version please.?

    Ex. I need to create a table like below

    SpaceName     AppName    SheetName                             SheetType

    Dev                  Test              Space_App_Sheets                Public

    Prod                 Test1            Demo                                      Private

    Show Less
  • forum

    Qlik NPrinting

    I cannot abort running tasks in NPrinting

    I had an issue where i could not start my QlikNPrintingmessagingservice service after installing the lattest windows paches. I managed to eventually r... Show More

    I had an issue where i could not start my QlikNPrintingmessagingservice service after installing the lattest windows paches.

    I managed to eventually restart this service using info in 

    https://community.qlik.com/t5/Official-Support-Articles/The-Qlik-NPrinting-messaging-service-and-the-Qlik-NPrinting/ta-p/1711303

    and https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/Troubleshooting/Qlik-NPrinting-Messaging-Service-startup-connection-problems.htm 

    It baffles me that this occurs and had to be manually resolved...

    However still none of my tasks works or restarted and all reports and caching holds showing 'running' or queued now for several hours. 

    https://localhost:4993/#/tasks/executions 

    andries_bos_0-1737371302809.png

    How could I force to stop all  (old) running tasks as the abort button or action does not respond at all ?

    Trying to stop a task will result in a no-sense message :

    andries_bos_0-1737379773805.png

     




    Show Less
Weekly Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!