topic Alternate state and if statement in QlikView

Alternate state and if statement

alisonpwallis — Tue, 05 Aug 2014 13:56:04 GMT

Hi,

I have a radar chart showing two groups - our organisation and the sector. The sector group can be divided into three categories and what I want to do is show on the chart label which group is being selected. I can do this with an if statement but the issue I'm having is that I have the sector data as an alternate state and I can't get the IF statement to work for the alternate state. Here is my statement:

=if([Inst/Inst Group]='Benchmark','Benchmark', if([Inst/Inst Group]='Competitor','UCAS competitor',if([Inst/Inst Group]='Other','Sector')))

Where do I put the alternate state in the syntax?

Thanks

Alison

Re: Alternate state and if statement

jerem1234 — Tue, 05 Aug 2014 15:57:13 GMT

Try this:

pick(match(only({State1}[Inst/Inst Group]), 'Benchmark', 'Competitor', 'Other'), 'Benchmark', 'UCAS competitor', 'Sector')

Hope this helps!

Re: Alternate state and if statement

alisonpwallis — Tue, 05 Aug 2014 16:15:59 GMT

That's great - thank you!

Alison