topic Re: Button - only show where value not equal to zero in QlikView

Button - only show where value not equal to zero

danielnevitt — Wed, 28 May 2014 12:46:53 GMT

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

Wed, 28 May 2014 12:48:30 GMT

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

Wed, 28 May 2014 12:52:24 GMT

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 — Wed, 28 May 2014 12:58:28 GMT

Hi Dariusz,

Thank you for your reply.

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

Regards,

Daniel