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: 
jduenyas
Specialist
Specialist

higher than 50,000

Hi all

I have a pivot table chart with 2 dimensions Industry and Customer and one expression of sum(transaction).

I wish to show only those who had total transactions of 50,000 or more.

The expression if(sum(Transactions)>50000,sum(transaction)) works but  the customers in the dimension who had less than 50000 remain in the list with ( - )  as total on their transactions. I wish to eliminate them from the list.

Any idea how to tackle that?

Thanks

Josh

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

Hi Josh,

Set the same expression but using set analysis instead of a conditional:

Sum({< Transactions = {"=Sum(Transactions) > 50000"} >} Transactions)

Hope that helps.

Miguel

View solution in original post

3 Replies
Miguel_Angel_Baeyens

Hi Josh,

Set the same expression but using set analysis instead of a conditional:

Sum({< Transactions = {"=Sum(Transactions) > 50000"} >} Transactions)

Hope that helps.

Miguel

jduenyas
Specialist
Specialist
Author

Well actually I lied.

In the expression I also have a lcolumn for Invoice number and a column for Department.

When removing those it works fine.

So plese disregard the question.

Thanks anyways.

Josh

jduenyas
Specialist
Specialist
Author

Thanks Miguel

Actually I resolved the problem and figuered out what I did wrong. See my own reply to myself.

Your solution of course, using set analysis is the a better apporoach and more elegant.

Thanks