Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

using 'above' funtion

Hi All,

I am having a scenario.In that I have to find out sales on month wise.For that am using

expression as above(Sum(Sales))-Sum(sales).In that case it showing month wise difference.But when I clicked

some month it is not showing any value.So please let me know how to proceed further

2 Replies
Not applicable
Author

Hi

What is your dimension Month ? If so

above(Sum(Sales))-Sum(sales) calculate the difference of sales between to 2 consecutive month

So if you clicked some month, you loose the previous dimension you need at least 2 month

JJ

disqr_rm
Partner - Specialist III
Partner - Specialist III

Try using set analysis instead. That should work for you.