Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ugurarslan
New Contributor

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
Contributor III

Re: Table: Show only SUM greater zero

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

cengizeralp
New Contributor III

Re: Table: Show only SUM greater zero

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


Load

..

..


Where [AR AMT USD]>0;

zebhashmi
Valued Contributor

Re: Table: Show only SUM greater zero

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

Re: Table: Show only SUM greater zero

Is there inside { } required???

Try below

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


Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
isingh30
Contributor III

Re: Table: Show only SUM greater zero

Thank you

ugurarslan
New Contributor

Re: Table: Show only SUM greater zero

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

Re: Table: Show only SUM greater zero

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

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
ugurarslan
New Contributor

Re: Table: Show only SUM greater zero

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

thiago_justen
Valued Contributor III

Re: Table: Show only SUM greater zero

I'd suggest you something like this:

Teste.gif

Cheers

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