Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have app in qliksense, which has got some selections applied and are hidden. Can any one help how to know those selections?
Hello, this is because qlik is responsive and the object is larger than the size available to display it. In the April version it is possible to reduce the grid according to the image below, maybe this will solve. Note that you can only change the size of the grid with the empty folder, without objects.
It help's ?
Hi Pablo,
Thanks for reply. But my question is how to unhide or know what all selections are applied? Where do i find those settings?
As per i know, Your Data model field store as HidePrefix. If so, For sure the selections won't show.
Then how the selections are made if is a hidden field?
Hey Prudhvi,
We are using a hide prefix in the main,
Syntax : HidePrefix
eg: HidePrefix='%';
If this statement is used, the field names beginning with a percentage will not be shown in the field name lists when the system fields are hidden.
For eg:
Load * inline [
%CarType, %CarTypeNo
Hatchback,1
Sedan,2
SUV,3
];
I have created this variable for the default selection of the dashboard when it is loaded. Now I only need to see Sedan when the dashboard loads.
So in the list box I will use the dimension as =[%CarType] and Default selected value as Sedan
then when the dashboard loads, default selection will be in Sedan and you can only see the Hidden selections applied in the top selection tab.
Hope this makes it clear.
Thanks,
Nicil O Paul
SET HidePrefix = '%';
CustomerID AS %CustomerID
Then create expression like this:
Count(%CustomerID) - To show the data
Check this for System fields.
https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/system-fields.htm