Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Button - only show where value not equal to zero

Hi,

I have a calculated expression field 'DIFFERENCE':

Sum(MARGIN)-((Sum(PAY)+(Sum(COLLECT))))

I would like to create a button that the user is able to click to show where this field does not equal zero.

Thanks for any help with this.

Regards,

Daniel

3 Replies
Not applicable

Do you need to mark non 0 rows using color or filter 0 rows from table?

Not applicable

Hi Daniel,

You can create a variable, say vFilter. Set vFilter = 0.

Create a button and add the action 'Set Variable' where the variable is vFilter and the value is if(vFilter = 0, 1, 0)

Then in your table, set the background color expression of 'DIFFERENCE' to:

if(vFilter, RGB(0,200,0), RGB(255,255,255))

danielnevitt
Creator
Creator
Author

Hi Dariusz,

Thank you for your reply.

I would like the button to filter the 0 rows from the table.

Regards,

Daniel