Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jduenyas
Not applicable

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
Not applicable

Re: higher than 50,000

Hi Josh,

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

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

Hope that helps.

Miguel

3 Replies
Miguel_Angel_Baeyens
Not applicable

Re: higher than 50,000

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
Not applicable

higher than 50,000

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
Not applicable

higher than 50,000

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