Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
neil-devlin
Contributor II
Contributor II

Set analysis not working

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]))

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus

View solution in original post

neil-devlin
Contributor II
Contributor II
Author

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

neil-devlin
Contributor II
Contributor II
Author

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