topic Re: Button Action to show only selected Color Limit Expressions in QlikView

Button Action to show only selected Color Limit Expressions

qlikwiz123 — Sat, 16 Nov 2024 18:02:59 GMT

I have this expression in a straight table and Color assigned to the Text based on my limits:

if(Sum(Expense)<5, Red(),

if(Sum(Expense)>=5 and if(Sum(Expense)<=10, Green(),

if(Sum(Expense)>10, Yellow()))

I need to create buttons to select these conditions.

Clicking Button1 should only show rows with Red color

Clicking Button2 should show rows with Green and clickign Button3 should show rowns only with Yello.

How do I do this?

Re: Button Action to show only selected Color Limit Expressions

dplr-rn — Mon, 28 Sep 2020 16:04:02 GMT

dont know your full context but you could try soemthing like below

variables per color e.g. vShowRed ,vShowGreen, vShowYellow

buttons will toggle variables between 1 (show) and 0

then your dimension declare using the an expression like below

if(Sum(Expense)<5 and $(vShowRed )=1, DIMENSION,

if(Sum(Expense)>=5 and Sum(Expense)<=10 and $(vShowGreen)=1, DIMENSION,

if(Sum(Expense)>10 and and $(vShowYellow)=1, DIMENSION))

show when null should be turned off.

please note if conditions can degrade performance (especially if data size is high). if possible try to move the conditions to set analysis or the script. need more detail to judge if it can be

Re: Button Action to show only selected Color Limit Expressions

qlikwiz123 — Mon, 28 Sep 2020 16:45:17 GMT

Doing this at Dimension level gives out 'Error in Calculation' even though it is correct.

Re: Button Action to show only selected Color Limit Expressions

Brett_Bleess — Wed, 21 Oct 2020 12:47:36 GMT

Will likely be most helpful if you can attach an example QVW which has the setup and your expected output. I believe the other option would be to use Actions to make the selections based upon the expression though, here is Help link regarding Actions:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Button2.htm#anchor-4

Not exactly sure how to make this work, but hopefully this may give you another approach to try.

Regards,
Brett