Filtering chart table

[Anonymous]

Hello friends of QV,

i have a chart table where I have a column (Status) that shows "UP" or "DOWN" using a simple logic (If col A > col B, "UP", "DOWN").

Is there a way i can now have a listbox containing the word "UP" and "DOWN" so that when i click on it, the chart table should then only show all values where column Status = "UP" or only values where column = "DOWN". Any ideas much appreciated.

This is how i am currently displaying the table. 

Customer	Current Year	Last year	Status
A	100	50	UP
B	200	500	DOWN
C	300	500	DOWN
D	400	300	UP

however, current Year and Last Year columns are calculated; so depending on what period is selected, the Current Year and Last Year will change. Hence, the status column is also dynamic.

thanks in advance

Derrell

[Anonymous · Accepted solution]

Hello,

PFA.

[Anonymous]

Thank you Ravichandra! much appreciated

[#4]

Hi Derrell ,

Based On u r Qvw i have tried smthing i think it might help u..

attaching u r updating  qvw also

[qlikviewwizard]

Hi jagan

Thank you Jagan. It is perfect.

[jagan]

Hi Derrell,

I am not sure why are you using 3 expressions for Status instead of using single expression.  Did you checked the file which I attached?

Regards,

jagan.

[#7]

Hi jagan ..it's really nice answer..i have learnt concat like super