Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
skkrishna
Contributor III
Contributor III

Hide field in front end or by Default select all values of DIM and Clear all shouldnt work on it or ANY other logic that shows TOTAL & TOTAL%

skkrishna_0-1654530228261.png

 

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.

skkrishna_1-1654530528528.png

 

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.

 

1 Solution

Accepted Solutions
skkrishna
Contributor III
Contributor III
Author

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

View solution in original post

1 Reply
skkrishna
Contributor III
Contributor III
Author

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