Show/Hide 0 values in straight table with button

Fred — Sat, 16 Nov 2024 02:47:18 GMT

Hi,

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.

This community post is kind of the same: Hide values that equal zero in a straight table
But I want to achieve this for multiple expressions, without writing giant if-statements.

What's the best way to tackle this issue?
I provided my sample qvw 🙂

Thanks for your input!

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

Fred — Fri, 09 Aug 2019 13:45:41 GMT

After some trail and error I managed to find a solution with some help of a colleague.
We added an extra expression to the table with an if statement that outputs a certain number if the other expressions equal 0.
The if statement output number (-1) is than used as a dimensions limit over my Item dimension to "filter out" the 0 numbers.

If someone else has an easier solution, please let me know!
I attached our solution.

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

Show/Hide 0 values in straight table with button

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