Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

fred_s
Contributor III

Summarize values in list

Hi,

Is there a way to quickly select Customers with a total amount between 25000 and 50000, where Total amount is something like "sum(Ordervalue)"?

Is there a way to create Ranges and put these ranges in a List where People can select them, say:

A > 50000
B > 25000
C > 10000
D <= 10000

Thanks in advance!

Tags (2)
1 Reply

Re: Summarize values in list

Look at the function "RANK" it solves your problem and you can use it as expression in a list box

Hope it heklps

Community Browser