topic Re: Reduce IF expression in QlikView

Reduce IF expression

Wed, 19 Aug 2015 04:42:30 GMT

I have a expression :

=if(PeriodOp='Quarter',Sum({<Quarter={$(vPriorQuarter)}>} O_TriGiaBan),if(PeriodOp='Month',Sum({<Month={$(vPriorMonth)}>} O_TriGiaBan),If(PeriodOp='Week',Sum({<WeekYear={$(vPriorWeek)}>} O_TriGiaBan))))

I wanna reduce IF expression and replace expression as follow :

=Sum({<Quarter={$(vPriorQuarter)} , Month={$(vPriorMonth)} , WeekYear={$(vPriorWeek)} >} O_TriGiaBan)

It dont work.. Quarter, Month, Week are selection...Please help me...!

Re: Reduce IF expression

gautik92 — Wed, 19 Aug 2015 04:47:06 GMT

Try this =Sum({$<Quarter={$(vPriorQuarter)} , Month={$(vPriorMonth)} , WeekYear={$(vPriorWeek)} >} O_TriGiaBan)

Re: Reduce IF expression

sunny_talwar — Wed, 19 Aug 2015 04:49:10 GMT

Try changing the definiation of your variables to these:

vPriorQuarter = If(PeriodOp = 'Quarter', yourCurrentExpression, '*')

vPriorMonth = If(PeriodOp = 'Month', yourCurrentExpression, '*')

vPriorWeek = If(PeriodOp = 'Week', yourCurrentExpression, '*')

and then use this expression and see if it works:

=Sum({<Quarter={$(vPriorQuarter)} , Month={$(vPriorMonth)} , WeekYear={$(vPriorWeek)} >} O_TriGiaBan)

Re: Reduce IF expression

Wed, 19 Aug 2015 04:51:27 GMT

It dont work @Gowtham

Re: Reduce IF expression

sunny_talwar — Wed, 19 Aug 2015 04:57:25 GMT

You might need double quotes like this:

=Sum({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} >} O_TriGiaBan)

Re: Reduce IF expression

Wed, 19 Aug 2015 05:57:51 GMT

=Sum({<Quarter={$(vPriorQuarter)} , Month={$(vPriorMonth)} , WeekYear={$(vPriorWeek)} >} O_TriGiaBan)

and

=Sum({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} >} O_TriGiaBan)

are correct, too .

Thank you so much @Sunny T

Re: Reduce IF expression

Mon, 24 Aug 2015 04:20:46 GMT

Hi sunindia , Can you please make me understand clearly about this code :

vPriorQuarter = If(PeriodOp = 'Quarter', yourCurrentExpression, '*')

and when I remove '*' , this code cant work ?

Re: Reduce IF expression

sunny_talwar — Mon, 24 Aug 2015 13:41:38 GMT

This code just mean that when PeriodOp is not equal to 'Quarter' then use *. and * in set analysis means select everything.

I hope that makes sense.

Best,

Sunny