Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Wiktor
Contributor
Contributor
‎2019-10-16 08:51 AM

Greater then average sales by client and town

Hello

I have to calculate avg sales per client in every town, in every month.  Then for every town mark clients with higher sales than average. I have little experience with "IF" and  I don't now how to make link client sales with town average.
I tried this:
IF((sum(Sales))>(Aggr((Sum([Sales])),[Town],[date.autoCalendar.YearMonth])/Count ( distinct [Client])),1,0)

686 Views
0 Likes
3 Replies
sunny_talwar
MVP
MVP
‎2019-10-16 08:54 AM

Would you be able to share some data and the output you expect to see from the data shared?

682 Views
Wiktor
Contributor
Contributor
‎2019-10-16 09:03 AM
Author

In response to sunny_talwar

clipboard_image_0.png

Is screenshot enough?

On the left - bolded is town, clients are below.   M_* is sales per client, Avg sales is for town.
Ideally for me will be situation when for every client I get Avg Sales identical as it is for Town. I don't know why sometimes there is value, but it is wrong.

676 Views
0 Likes
sunny_talwar
MVP
MVP
‎2019-10-16 09:10 AM

In response to Wiktor

not entirely sure I understand the issue still

673 Views
0 Likes