Convert if to pick Match

[avinashkk696]

Hi Guys,

I have a requirement where I want to convert my if statement to pick (match()). But I am confused on how we do it.

My Expression:

if(GetSelectedCount(Country)=0, sum(revenue),
if(GetSelectedCount(country)>0 and GetSelectedCount(state)=0,Sum(Sales),
if(GetSelectedCount(State)>0,count(Employees)
)
))

[Shubham_Deshmukh]

Hi @avinashkk696 ,

Check out this thread,

https://community.qlik.com/t5/QlikView-App-Development/How-to-write-different-formulae-for-each-cell...