Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
pkelly
Specialist
Specialist

aggr function

I am struggling with the attached...

I am trying to show how many customers sales have grown / how many have decreased (same counts as decreased)...

I am on QV 8.2 so please bear this in mind with any response...

Thanks in advance for any assistance provided...

1 Solution

Accepted Solutions
Not applicable

maybe this is more clear...

View solution in original post

4 Replies
pkelly
Specialist
Specialist
Author

Anyone any suggestions on this?

Even if it is to say it cannot be done....

Not applicable

Hi Paul,

excuse me but I speek only a little english.

I'm looking for the best response for you, by now I found only an "half" response.

I fear that you cannot calculate in this chart the number of customers with growthing sales count, or decreasing one.

You need another dimension, resulting of the customers' aggregation for sales growth or decrease.

You can view total sales for year in the "total" column of a pivot table.

Look at my doc!

I hope it is useful.

Bye

Not applicable

maybe this is more clear...

pkelly
Specialist
Specialist
Author

Thanks Roberta this worked great....