Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

liam_hanninen
Contributor

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?

Tags (2)
2 Replies
plexpro52
Contributor

Re: Above and Below functions break with selection

Hello Liam,

Did you resolve this?

René

liam_hanninen
Contributor

Re: Above and Below functions break with selection

No