Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have created two fields Total & Total% as per below link - https://community.qlik.com/t5/New-to-Qlik-Sense/Qlik-sense-To-calculate-Total-amp-Percentage-of-Tota...
Now when a user Select a city TOTAL & TOTAL% are not showing up as DIM value =1 is getting selected as shown in the image.
Requirement here is DIM = ALL values has to be selected and DIM should not be seen in UI(Front end) or in Current selections Tab
I have locked the DIM selections using ACTIONS in qliksense sheet, But when I'm trying to hide the column in script (SET HIDE PREFIX) the actions aren't working.
the requirement is DIM should be HIDDEN
all the values in DIM should be selected.
and CLEAR all should not work on DIM field.
or
ANY other logic that shows TOTAL & TOTAL%
Please help me on this.
Here is the Solution:
Step -1 Add Action Select all values in Dim & "LOCK IT"
Step 2 - Add this script
TAG FIELDS "Dim" With $HIDDEN;
doing this we can achieve the solution - Dim hidden, all values selected & locked , Clear all doesnt work for DIM
Here is the Solution:
Step -1 Add Action Select all values in Dim & "LOCK IT"
Step 2 - Add this script
TAG FIELDS "Dim" With $HIDDEN;
doing this we can achieve the solution - Dim hidden, all values selected & locked , Clear all doesnt work for DIM