Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expresion that displays between and greater than values

Hi -

Can someone please help me write two expressions that will help with displaying the following:

1. Values that are >$100 and <$999

2. Values that = $1000 and greater

Thank you for your help!

1 Solution

Accepted Solutions
MayilVahanan

Hi

Try like this

=Sum({<Values = {">100 < 999"}>}Sales)

=Sum({<Values = {">=1000"}>}Sales)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

4 Replies
MayilVahanan

Hi

Try like this

=Sum({<Values = {">100 < 999"}>}Sales)

=Sum({<Values = {">=1000"}>}Sales)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

See attached for set analysis example.

Not applicable
Author

Thank you that worked! Is there any way to hide 0's?

maksim_senin
Partner - Creator III
Partner - Creator III

Hi

Personally I use three approaches:

1. use of set analysis, something like this - Sum({<Revenue={">=101<=998"}>} Revenue)

2. use of class() function in a calculated dimension - please refer to manual and samples

3. precalculated (i.e. in load script) "price basket" - a  value assigned to a new field of transaction basing on a range of values, i.e. the field contains "100-999" if its value is >100 and <999, ">1000" if its values is >1000 and so on.

1st and 2nd are quick in implementation, but affects performanc too much, 3rd requires more work but corresponds to best practice from performance point of view.

Best regards,

Maxim