topic How to Create/Use a Button to Filter on Only Highlighted Values in QlikView

How to Create/Use a Button to Filter on Only Highlighted Values

oliveton — Sat, 16 Nov 2024 01:23:38 GMT

I have a straight table where I have some selections highlighted in red. I'm trying to use a button to filter only on the values in red. How do I go about doing this and should the expression go under actions under the button properties ?

Thanks

Re: How to Create/Use a Button to Filter on Only Highlighted Values

Taoufiq_Zarra — Wed, 29 Jan 2020 20:37:34 GMT

what is the expression used to identify red values?

The idea is to use this expression in the Action tab of the button.

if you want you can share a sample data or qvw file

Re: How to Create/Use a Button to Filter on Only Highlighted Values

oliveton — Thu, 30 Jan 2020 13:42:43 GMT

This is the expression to define red values. Do I just put that same exact expression under search string in the action tab?

Thanks

if(min(BISalesResult) <= -9203.54 , LightRed ())

Re: How to Create/Use a Button to Filter on Only Highlighted Values

Brett_Bleess — Mon, 24 Feb 2020 22:06:38 GMT

Believe you need to strip out the color portion of that expression, but that should do the trick after that, so believe it should just be Min(BISalesResult)<=-9203.54 in this case. I am not great at the development stuff though, so hopefully someone can double-check me here and confirm this is correct.

Regards,
Brett