# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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.

Thanks

Ugur

10 Replies
Contributor III

## Re: Table: Show only SUM greater zero

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

New Contributor III

## Re: Table: Show only SUM greater zero

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

..

..

Where [AR AMT USD]>0;

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

Thank you

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.
New Contributor

## Re: Table: Show only SUM greater zero

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

Valued Contributor III

## Re: Table: Show only SUM greater zero

I'd suggest you something like this:

Cheers

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