Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
liam_hanninen
Creator
Creator

Above and Below functions break with selection

I'm hoping there is a common fix for this since I'm sure others have run into this. But I have not found a solution online yet.

I am using above() in a chart to sum 4 trailing weeks into a single week value. But when I select  a few weeks the last most weeks appear artificially low because there are no values 'above' them; they have been filtered out. If I manually exclude week from the selection like Weekending=, I then prevent the user from selecting these weeks (for this chart). How can I maintain the above() calculation when the dimension has been filtered?

2 Replies
plexpro52
Creator
Creator

Hello Liam,

Did you resolve this?

René

liam_hanninen
Creator
Creator
Author

No