Convert if to pick Match

avinashkk696 — Sat, 16 Nov 2024 04:07:20 GMT

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)
)
))

topic Convert if to pick Match in QlikView

Convert if to pick Match

Re: Convert if to pick Match