
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Table: Show only SUM greater zero
Dear all,
I have created a table with all different dimensions + one measurement which is the sum of AR = sum([AR AMT USD]).
But when creating the tables the tables show also values where the amount is 0. I only want to show the AR amount which is anything greater than 0 USD.
Can you please help me?
Thanks
Ugur
- « Previous Replies
-
- 1
- 2
- Next Replies »

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try like this - only({<AR Amount ={">{0}"}>}sales).


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can delete records at script side by using "where"
Load
..
..
Where [AR AMT USD]>0;


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
if(sum([AR AMT USD])>0,sum([AR AMT USD]),'')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there inside { } required???
Try below
Sum({<AR Amount ={">0"}>}sales).
Regards,
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you very much for all of your answer, but unfortunately non of these worked , what I need is the following:
Now the table looks like this:
User Name | Sum([AR Amt USD]) |
Derk Boss | 321 |
Agnes Injury | - |
Robbie Williams | - |
Albert Einstein | 492 |
Alexander the Great | 117 |
George Clooney | 190 |
And needs to be like this:
User Name | Sum([AR Amt USD]) |
Derk Boss | 321 |
Albert Einstein | 492 |
Alexander the Great | 117 |
George Clooney | 190 |
So eleminate Agnes Injury and Robbie William.
Thanks
Ugur

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
go to chart property > add ons > Data handling > untick include zero values
Regards,
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This doesn't work with more dimension or more measurements.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'd suggest you something like this:
Cheers
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago

- « Previous Replies
-
- 1
- 2
- Next Replies »