topic Re: if...elseif... in calculated dimensions in QlikView

if...elseif... in calculated dimensions

Wed, 20 Feb 2013 15:28:40 GMT

I need to reflect in a column graph (stacked) how many helpdesk jobs are completed on time, completed late and still outstanding. So far through a calculated dimension I've managed to show number of jobs completed late and on time by using the following if statement:

=if (FINISH_DATE >> DUE_DATE, 'Late','On time')

When I used if...elseif...else...end if I couldn't make it work, it tells me I've got garbage expression. What can I do if I have more than two options to display?

Many thanks in advance

Re: if...elseif... in calculated dimensions

Gysbert_Wassenaar — Wed, 20 Feb 2013 15:33:25 GMT

You can nest if statements:

if( condition1,

result1,

if( condition2,

result2,

result3)

)

Re: if...elseif... in calculated dimensions

Wed, 20 Feb 2013 15:40:41 GMT

genius! thank you so much!

Re: if...elseif... in calculated dimensions

Thu, 14 Mar 2013 16:25:39 GMT

Hi,

I have a similar problem and didn't want to start a new discussion just for it. This is what I have and it seems fine till the second IF and after that apparently it's 'garbage'. It is an expression in a straight table:

if(

YEAR_END_NUMBER = 12

AND

month(CAL_DATE) > 3

AND

month(CAL_DATE) < 7 ,

sum(IM*GB)),

if (

YEAR_END_NUMBER <> 12

AND

month(CAL_DATE) > YEAR_END_NUMBER + 3

AND

month(CAL_DATE) < YEAR_END_NUMBER + 7,

sum(IM*GB),

'no data')

Re: if...elseif... in calculated dimensions

Gysbert_Wassenaar — Thu, 14 Mar 2013 17:15:36 GMT

Try it like this:

if(

(YEAR_END_NUMBER = 12

AND

month(CAL_DATE) > 3

AND

month(CAL_DATE) < 7 )

( YEAR_END_NUMBER <> 12

AND

month(CAL_DATE) > YEAR_END_NUMBER + 3

AND

month(CAL_DATE) < YEAR_END_NUMBER + 7

sum(IM*GB),

'no data')

Re: if...elseif... in calculated dimensions

Fri, 15 Mar 2013 09:09:30 GMT

Thank you! This worked fine

By the way, why does it not work for calculated dimension? Is it for calculated expressions only?