Recent Discussions
-
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 MoreBonjour à 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 ?
-
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 MoreHi 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.
-
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 MoreHello,
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.
-
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 MoreHi 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
-
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 MoreHello 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!
-
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 MoreHi,
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!
-
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 MoreI 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
-
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 MoreI 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
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/executionsHow 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 :
-
Qlik sense Writeback table how to use "Options Field" in drop down
Hello- I have a Writeback table where I would like to use a drop down and set the options for the drop down in the Data Load editor. I thought I saw ... Show MoreHello-
I have a Writeback table where I would like to use a drop down and set the options for the drop down in the Data Load editor. I thought I saw how to do this here :https://community.vizlib.com/support/solutions/articles/35000156684-vizlib-writeback-table-properties-input-field-options#Options-Field, but I can't seem to get the options to populate in the drop down. I have not found documentation on this besides this link.
I am especially confused on what to put for "Options Field Separator" (I'm not even sure what this means).
This is what I have so far:
DLE:
Qlik:
(when I used "dimension" instead of creating a column, it created 3 separate rows in the table-one for each value-rather drop down options).
Any help would be much appreciated! My table is going to have A LOT of drop downs with many options so being able to easily define them in the DLE is essential.
-
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 MoreI'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.