Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
aaronnayan
Contributor III

SAimple Set anlaysis

Hi Experts

How would i write

To show -

The Highest number of sales (field) made from which City (dimension)?

----------------------------------------------------------------------------------------------

// ie       SUM( {$<Max(Sales )] = {"*"} >}City)??????

Thanks Guys

1 Solution

Accepted Solutions
Partner
Partner

Re: SAimple Set anlaysis

Hello Aaron,

without an set analysis clause i think you can also write:

max(aggr(sum(Sales),City))

View solution in original post

3 Replies
Partner
Partner

Re: SAimple Set anlaysis

max({<City={'YourCity'}>} Sales)

Partner
Partner

Re: SAimple Set anlaysis

If you want to show the max sales of each city, you'd create a chart with City as the dimension and max(Sales) as the expression.

Partner
Partner

Re: SAimple Set anlaysis

Hello Aaron,

without an set analysis clause i think you can also write:

max(aggr(sum(Sales),City))

View solution in original post