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: 
paulwalker
Creator III
Creator III

Need Help??

Hi Community,

I have Quarter dimension and Qty Measure.

i want calculate Quarter on Quarter growth in Sales..

Thanks in Advance.........

11 Replies
paulwalker
Creator III
Creator III
Author

But small prob, I have Q1 data also..

but here it's not showing....

Once you take Qty in listbox,

swuehl
MVP
MVP

Yes, you have data for Q1. And I also noticed, your data spans two years.

If you aggregate your data on Quarter basis across all available years, there is no preceding Quarter for the first quarter to calculate the percentage change (like in a list box, there is no Quarter above Q1).

If you want to consider the Quarter on a year basis, then you could include in the advanced aggregation dimension list and maybe average the change percentage across years.

Not sure if you understand what I am trying to say, maybe the attached updated version helps.