topic Re: Show/Hide 0 values in straight table with button in App Development

Show/Hide 0 values in straight table with button

Vigneshhhhh — Thu, 18 Mar 2021 13:33:55 GMT

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

Re: Show/Hide 0 values in straight table with button

Or — Thu, 18 Mar 2021 13:41:56 GMT

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.

Re: Show/Hide 0 values in straight table with button

joaopaulo_delco — Thu, 18 Mar 2021 13:51:01 GMT

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.

Re: Show/Hide 0 values in straight table with button

Vigneshhhhh — Thu, 18 Mar 2021 15:04:23 GMT

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

Re: Show/Hide 0 values in straight table with button

Or — Thu, 18 Mar 2021 15:06:29 GMT

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.

Re: Show/Hide 0 values in straight table with button

Vigneshhhhh — Thu, 18 Mar 2021 15:09:32 GMT

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

Re: Show/Hide 0 values in straight table with button

joaopaulo_delco — Thu, 18 Mar 2021 16:56:42 GMT

See the solution app attached.

Re: Show/Hide 0 values in straight table with button

Vigneshhhhh — Fri, 19 Mar 2021 11:17:17 GMT

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

Re: Show/Hide 0 values in straight table with button

joaopaulo_delco — Fri, 19 Mar 2021 14:16:51 GMT

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.

Re: Show/Hide 0 values in straight table with button

Vigneshhhhh — Sun, 21 Mar 2021 02:08:06 GMT

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

Re: Show/Hide 0 values in straight table with button

Lech_Miszkiewicz — Sun, 21 Mar 2021 04:18:56 GMT

I would create 2 objects (one with checkbox on another with off) and put them in containeer. Then you can use buttons to controll visibillity of the object

Re: Show/Hide 0 values in straight table with button

Vigneshhhhh — Mon, 22 Mar 2021 08:14:54 GMT

Could you please provide step by step "users" field to create a bookmark, How to create set expression in a book mark. could please share screen short

Re: Show/Hide 0 values in straight table with button

joaopaulo_delco — Mon, 22 Mar 2021 12:00:16 GMT

Hi @Vigneshhhhh !

See step by steb below:

1) Write the expression on filter and press "Enter" to apply the selections.

2) Click on bookbark icon, then select "Create a new bookmark" (My qlik sense is in portuguese)

3) Give a name for your bookmark

That's it!