topic Re: How to combine set analysis with an if function in QlikView

How to combine set analysis with an if function

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

I have the following expression

sum(aggr(sum(if(Door1 + Door2 = 1 , Door3)), Outlet))

I want to incorporate the set analysis , {< [FA Group], SKU, Year = {$(vMaxYear)} >} into the expression,

How i do i this?

Thanking you in advance.

Kind regards

Nayan

sunilkumarqv — Tue, 16 May 2017 06:19:54 GMT

hi Nayan,

Please try this

sum({< [FA Group], SKU, Year = {$(vMaxYear)} >} aggr(sum({< [FA Group], SKU, Year = {$(vMaxYear)} >} if(Door1

+ Door2 = 1 , Door3)), Outlet))

Anonymous — Tue, 16 May 2017 06:42:57 GMT

Thank you Sunil. It worked.

Kind regards

Nayan