topic Re: Set analysis not working in QlikView

Set analysis not working

neil-devlin — Thu, 23 Sep 2021 12:51:37 GMT

Hi,

Wondering if anyone can help me with a set analysis issue. The below expression works if I make the week number = to 38 (our current week for reporting) or equal to a variable that also equals 38, however if I were to change the value to any other number the cell goes to null, despite their being a value for all 52 weeks. Curiously despite me using set analysis the expression is also influenced by selecting the week filter, so if choosing anything other than the current week (38) the cell will return a null value. Hopefully I've explained this issue well enough.

Expression:

Sum(Aggr(Sum ({$<Week={37},Year={$(vLFLCurrYr)},Date=,[Retailer Status]={'OPEN'},
IT_System_Week= > } DISTINCT [Budget Nett Sales]),[Week],[Retailer Code],[HRL Finance Group]))

Re: Set analysis not working

marcus_sommer — Thu, 23 Sep 2021 13:03:44 GMT

You may try to put your set analysis in the outer aggregation, too.

- Marcus

Re: Set analysis not working

neil-devlin — Thu, 23 Sep 2021 13:17:49 GMT

Thanks for the reply, I'm not sure of the syntax for this? Sorry if thats a stupid question

Re: Set analysis not working

neil-devlin — Thu, 23 Sep 2021 13:21:58 GMT

Apologies I've figured out the syntax and that indeed works, thanks for your help!