How to remove values having letter x from the table?

[paweln]

Dear All,

I have simple tabel with no agregations, just dimensions. One column has ID numbers consisting of letters and numbers. I would like to have posibility of hiding (prefebly by pressing some button) all ID numbers having X and Y letters in them. 

How can i do it?

[Mauritz_SA · Accepted solution]

Hi there

You can use the following expression for your dimension:

=IF(vFieldXY,AGGR(Only({<ID = {"=Len(ID)=Len(PurgeChar(ID,'xy'))"}>} ID),ID),ID)

Then create a variable called a variable called vFieldXY and make the default value 0. You can then use the Variable Input extension (with the button option) with two buttons (with labels of your choice) with values 0 and 1. When the user pushes the button with the 1 value, then the IDs with x or y will be hidden.

You can spend some time in actually replacing the variable values with 'ID' and the aggregation function if you want to - the single and double quotes just make it tricky.

Hope this helps.

Regards,

Mauritz

[vunguyenq89 · Accepted solution]

Hi,

You can use "Button for Navigation" object which is part of the default Qlik Dashboard bundle. Use action "Set variable value" of the button to toggle values 1/0 for a variable, then in the table use a calculated dimension with a condition check on the variable to decide whether to show/hide IDs containing X,Y.

Sample application is attached. Hope this helps!

BR,

Vu Nguyen