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%

[SK28]

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.

[SK28 · Accepted solution]

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