topic Re: IF statement - Multiple criteria in QlikView

IF statement - Multiple criteria

george456 — Wed, 25 Nov 2020 16:16:04 GMT

Dear community

I need some help with the following:sum(if(Year2Date(PERIOD,-1,if(MONTH(LatestDate)>11,1,MONTH(LatestDate)+1),LatestDate),IF(BRAND='Pr1' , 'Pr2',$(vMeasure))))/1000

I have the above formula, I am struggling to get the multiple IF criteria to function correctly. What would be the correct syntax.

Please help

Regards

Re: IF statement - Multiple criteria

sunny_talwar — Wed, 23 Oct 2019 19:29:48 GMT

What exactly is your condition here?

If(Year2Date(PERIOD, -1, If(Month(LatestDate) > 11, 1, Month(LatestDate)+1),LatestDate)

What are you checking Year2Date to?

Re: IF statement - Multiple criteria

george456 — Wed, 23 Oct 2019 19:31:02 GMT

Dear Community

I have sorted the problem with the below formula:

SUM({<BRAND={'Pr1','PR 2'}>}if(Year2Date(PERIOD,-1,if(MONTH(LatestDate)>11,1,MONTH(LatestDate)+1),LatestDate),$(vMeasure)))/1000

Thanks

Re: IF statement - Multiple criteria

george456 — Wed, 23 Oct 2019 19:32:09 GMT

Thanks for quick reply, I managed to sort it out.

Regards