Filtering table based on different calculation conditions

[rsdhavle]

We have scenario like there is one table of Deals. And we are doing different calculations as CYYTD Wins, Losses etc..Now we want to filter deals table based on these calculations lets say If we click on CYYTD wins the deals corresponding to CYYTD Wins should be displayed in the table, similarly for losses etc. How can we approach this?

[qlikoqlik]

Hi Rohan

Create a calculated field to store a value for wins and looses.  then you can use this field in the list box

Thanks and regards

Padma