topic Re: If condition in QlikView

If condition

Mon, 31 Mar 2014 16:49:09 GMT

The calculation below is not working,The if conditions are not getting satisfied. Please help

=IF(MATCH(FC.DATE_FISCAL_MONTH_NUM_LONG,3,6,9,12)>0 and Type='P',

SUM({<FC.DATE_FISCAL_YEAR_LONG={$(vCurrentYear)},FC.DATE_FISCAL_MONTH_NUM_LONG={">=$(vPrevMonth)<=$(vCurrentMonth)"}>}([Direct Hours]/200)),

SUM({<FC.DATE_FISCAL_YEAR_LONG={$(vCurrentYear)},FC.DATE_FISCAL_MONTH_NUM_LONG={">=$(vPrevMonth)<=$(vCurrentMonth)"}>}([Direct Hours]/160))

)

Re: If condition

MK_QSL — Mon, 31 Mar 2014 16:53:38 GMT

try

=IF(MATCH(FC.DATE_FISCAL_MONTH_NUM_LONG,3,6,9,12)>0 and Type='P',

SUM({<FC.DATE_FISCAL_YEAR_LONG={'$(vCurrentYear)'},FC.DATE_FISCAL_MONTH_NUM_LONG={">=$(vPrevMonth)<=$(vCurrentMonth)"}>}([Direct Hours]/200)),

SUM({<FC.DATE_FISCAL_YEAR_LONG={'$(vCurrentYear)'},FC.DATE_FISCAL_MONTH_NUM_LONG={">=$(vPrevMonth)<=$(vCurrentMonth)"}>}([Direct Hours]/160))

)

Re: If condition

Mon, 31 Mar 2014 16:58:18 GMT

its giving me the same numbers, The set analysis i made for Year and Quarter are working but for Curr month
Vs Prev month, this is coming wrong

Re: If condition

MK_QSL — Mon, 31 Mar 2014 16:59:46 GMT

What is your variable definition for the above mentioned variables?

Re: If condition

Mon, 31 Mar 2014 17:04:05 GMT

Current Month:

=Max(IF(FC.DATE_FISCAL_YEAR_LONG=$(vCurrentYear),FC.DATE_FISCAL_MONTH_NUM_LONG))

PrevMonth:

=if($(vCurrentMonth)=1,12,$(vCurrentMonth) -1)

If the Month is multiple of 3(like 3,6,9,12) then I need to divide the direct hours by 200 else by 160

Re: If condition

Anonymous — Mon, 31 Mar 2014 17:06:52 GMT

And, what is the value of FC.DATE_FISCAL_MONTH_NUM_LONG at time and point of calculation? Is it defined?

Re: If condition

Mon, 31 Mar 2014 17:27:43 GMT

Yes it defined contains number(1,2,3..12)

Re: If condition

Anonymous — Mon, 31 Mar 2014 17:34:49 GMT

OK, I have to clarify my question...

If you use your expression in a chart where this field is an dimension, the match() function should work. To make sure, just add it as an additional dimension. If you use it in any other way, and multiple values are selected (or available) in this field, match returns null. So "if" condition returns false.

Re: If condition

Mon, 31 Mar 2014 17:42:50 GMT

So how you want me to modify this one. Please help me.if you want I can share the sample file with you

Re: If condition

Anonymous — Mon, 31 Mar 2014 17:52:30 GMT

Just upload the file, and I (or anybody else) will take a look.

Re: If condition

Mon, 31 Mar 2014 18:56:46 GMT

Thanks Micheal,

I have not cleared the cache and was trying different calculations, Once I cleared the cache and re applied the calculation it has worked.

Thanks again

have a good day!