Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
JoshHazelton
Contributor
Contributor

Need sum of sales to be greater than $50k

Hello,

I am trying to make my sum of total sales (measure) be greater than or equal to $50k. I want to eliminate all lines that are under $50k from the sheet. Not sure whether a set analysis will work or if there is something I have to change in one of my dimensions. 

Thanks in advance

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Have you tried an expression like if(sum(sales)>=50000,sum(sales),Null()) ?

Hard to say exactly without some sample data.

John

(aka johncaqc)

View solution in original post

3 Replies
Anonymous
Not applicable

Have you tried an expression like if(sum(sales)>=50000,sum(sales),Null()) ?

Hard to say exactly without some sample data.

John

(aka johncaqc)

JoshHazelton
Contributor
Contributor
Author

Hey John, 

Thank you for your response. This as well as a few other suggested expressions did not work. I believe I need to use dimension limitations in order for all columns to go away not just sales amount when the sales amount is under 50k. Any way you could help with this?

Thanks,

Josh

Anonymous
Not applicable

Can you share some sample data, and expected output?

John

(aka johncaqc)