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: 
ugurarslan
Creator
Creator

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

10 Replies
isingh30
Specialist
Specialist

Try like this - only({<AR Amount ={">{0}"}>}sales).

cengizeralp
Contributor III
Contributor III

You can delete records at script side by using "where"


Load

..

..


Where [AR AMT USD]>0;

zebhashmi
Specialist
Specialist

if(sum([AR AMT USD])>0,sum([AR AMT USD]),'')

PrashantSangle

Is there inside { } required???

Try below

Sum({<AR Amount ={">0"}>}sales).


Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
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 🙂
isingh30
Specialist
Specialist

Thank you

ugurarslan
Creator
Creator
Author

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

PrashantSangle

go to chart property > add ons > Data handling > untick include zero values

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
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 🙂
ugurarslan
Creator
Creator
Author

This doesn't work with more dimension or more measurements.

Thiago_Justen_

I'd suggest you something like this:

Teste.gif

Cheers

Thiago Justen Teixeira Gonçalves
Farol BI
WhatsApp: 24 98152-1675
Skype: justen.thiago