Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Vigneshhhhh
Contributor II
Contributor II

Show/Hide 0 values in straight table with button

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 

1 Solution

Accepted Solutions
joaopaulo_delco
Partner
Partner

Hi @Vigneshhhhh !

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

joaopaulo_delco_0-1616162873363.png

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.

joaopaulo_delco_1-1616163388330.png

 

View solution in original post

12 Replies
Or
Master
Master

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
Partner
Partner

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
Contributor II
Contributor II
Author

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
Master
Master

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
Contributor II
Contributor II
Author

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
Partner
Partner

See the solution app attached.

joaopaulo_delco_0-1616086584420.png

 

Vigneshhhhh
Contributor II
Contributor II
Author

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
Partner
Partner

Hi @Vigneshhhhh !

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

joaopaulo_delco_0-1616162873363.png

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.

joaopaulo_delco_1-1616163388330.png

 

View solution in original post

Vigneshhhhh
Contributor II
Contributor II
Author

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