Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
simonqv16
New Contributor III

Sales range as chart dimension

Hi,

Does any know how to script Sales Range as a dimension of a chart to show number of salesperson in each of such range?   Thanks.

SalespersonSales Record in Mar
A20
A80
A40
B55
B75
C50

Expected Result

Total Sales < 100     :    1 sales person (C)

Total Sales > 100     :    2 sales person (A & B)

Tags (1)
1 Solution

Accepted Solutions

Re: Sales range as chart dimension

May be with a calculated dimension like this

=Aggr(If(Sum([Sales Record in Mar]) < 100, 'Total Sales < 100', 'Total Sales >= 100'), Salesperson)

Capture.PNG

1 Reply

Re: Sales range as chart dimension

May be with a calculated dimension like this

=Aggr(If(Sum([Sales Record in Mar]) < 100, 'Total Sales < 100', 'Total Sales >= 100'), Salesperson)

Capture.PNG