Chart expression - combine 3 ifs

Thu, 16 Jun 2011 21:56:51 GMT

I am new to QlikView, so I may just be missing something obvious here, but I could use some help.

I am trying to create a chart that has a branch number, and then its trend based on whether the current month is greater/less/equal its 6 month average.

I currently have Branch as a Dimension, and then Trend as 3 seperate Expressions:

Trending Up: if(Persistency>6MoAvg,'Up')

Trending Down: if(Persisentcy<6MoAvg,'Down')

Trending Same: if(Persistency=6MoAvg,'Same')

So I get something like:

Branch Trending Up Trending Down Trending Same

1 Up - -

6 - Down -

9 - - Same

But I want to combine these in to one Expression just called Trending and get something like:

Branch Trending

1 Up

6 Down

9 Same

I'm having trouble figuring out how to do if,if,else instead of just if,else - if that makes sense. B/c I have three cases, but I want to combine them.

I am sure this is just some simple syntax I'm not thinking of / being able to find. Any suggestions?

Chart expression - combine 3 ifs

pat_agen — Thu, 16 Jun 2011 22:20:11 GMT

hi,

try

if(Persistency>6MoAvg,'Up',

if(Persisentcy<6MoAvg,'Down','Same') )

should give

if better than 6moAvg then

else

if worse than 6moAvg then

down

else

same

see if it works

Chart expression - combine 3 ifs

Thu, 16 Jun 2011 22:22:58 GMT

That did it - thanks! I'd tried some variations of that and just hadn't gotten it quite right.

topic Chart expression - combine 3 ifs in QlikView

Chart expression - combine 3 ifs

Chart expression - combine 3 ifs

Chart expression - combine 3 ifs