Show/Hide 0 values in straight table with button

[Vigneshhhhh]

Hi All,
I want the user to be able to include or exclude 0 values in different columns from a straight table.
Basically when they press a button, Sales equal to 0 is included or excluded.
The buttons are not absolutely necessary, any other selection method is also fine

@Fred 

[Or]

This would get pretty ugly...

I think you'd have to turn on the global Hide 0 values option, then for each measure, something like

If((vSelector = 'Sales' AND Sum(Sales)<>0) OR( vSelector = 'QTY' and Sum(QTY)<>0),YourMeasureFormulaHere)

Your button or selector would update a variable called vSelector in this scenario, obviously.

This could probably also be written via set analysis but it'd be the same thing just with different syntax.

[joaopaulo_delco]

Hi @Vigneshhhhh !

     This is my suggestion:

1) Open your app and go to the Customer, product or another dimension your have and search for Sales = 0, like below:

=Sum(Sales)=0

 2) After do the selections, create a bookmark.

3) Using the button component, apply the "Apply bookmark" action and choose your recent bookmark created.

[Vigneshhhhh]

User sum(Sales) sum(Other) Product
total 1,76,50,731.00 1,48,45,607.00
A1 46,14,859.41 46,14,859.41 C1
A2 0.00 0.00 e1
A3 38,14,312.98 38,14,312.98 f1
A4 31,62,262.16 31,62,262.16 C1
A5 0.00 1,06,966.82 e1
A6 0.00 0.00 f1
A7 23,82,971.99 0.00 C1
A8 19,24,829.83 13,95,711.18 e1
A9 0.00 0.00 f1
A10 17,51,495.05 17,51,495.05 v1 In the above table
I want the user to be able to include or exclude 0 values in different
columns from a straight table.
Basically when they press a button, sum(Sales) and sum(other) equal to 0
means it should excluded of entire row.for your reference i have highlight
yellow mark
The buttons are not absolutely necessary, any other selection method is
also fine

[Or]

That is what the code I suggested would do. You'd have to apply it to *every* measure. You can't suppress zero/null on just one column, as far as I know.

[Vigneshhhhh]

I want the user to be able to include or exclude 0 values in different
columns from a straight table.
Basically when they press a button, sum(Sales) and sum(other) equal to 0
means it should excluded of entire row.for your reference i have highlight
yellow mark PFA
The buttons are not absolutely necessary, any other selection method is
also fine

[joaopaulo_delco]

See the solution app attached.

[Vigneshhhhh]

In my table 200k user are there, if I didn't manually select entire user and I am unable to create a book mark any other suggestion please.. 

[joaopaulo_delco · Accepted solution]

Hi @Vigneshhhhh !

    You don't need to select manually the users. Look the way I select the users to create a bookmark:

You also don't need to create a bookmark to every qlik sense user. You (professional license) could define the bookmark as default and it will work for all users.

Other option is using the option "Select values matching search criteria" on button action.

Select the User Field and put the formula 

='=Sum(Sales)+Sum(Other)>0'

See the updated app attached.

[Vigneshhhhh]

In my qliksense apps "Select values matching search criteria" Option is not available 

Could you please provide step by step of   users to create a bookmark