topic SET expression after change to IF expression give wrong result in QlikView

SET expression after change to IF expression give wrong result

paulyeo11 — Wed, 21 Feb 2018 02:57:02 GMT

Hi All

Below expression work fine :-

Sum(Aggr(SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales/1), GROUP_TYPE))

when I change the above expression to below , it return wrong result.

Sum(if(Year_n<'2',sales/Rate,GROUP_TYPE))

May i know where go wrong ?

Paul

Re: SET expression after change to IF expression give wrong result

prma7799 — Wed, 21 Feb 2018 04:19:19 GMT

Try this

Sum(if(Year_n<'2',(Sum(sales) / avg(Rate)),GROUP_TYPE))

Sum(if(Year_n<'2',(Sum(sales) / Sum(Rate)),GROUP_TYPE))

Re: SET expression after change to IF expression give wrong result

paulyeo11 — Wed, 21 Feb 2018 05:00:35 GMT

Hi Sir

Enclosed Table 1 using SET expression , the result correct.

I try using your suggest expression on IF not working.

Paul Yeo

Re: SET expression after change to IF expression give wrong result

prma7799 — Wed, 21 Feb 2018 05:15:54 GMT

Try this

=if(Year_n<'2',(Sum(sales) / avg(Rate)), (GROUP_TYPE))