Show sales > 0

[barbora_s]

Hi guys,

new to Qlik, would appreciate help.

Using the Cloud Sense. Putting together a bar chart with dimension Customer. How can i show only customers, where SUM(Sales > 0)? - in case below it would then be showing sales for X and Z.

Customer	Sales
X	1
Y	0
X	2
Z	1
Y	0
W	0

Thanks!!

B.

[OmarBenSalem]

as dimension:

Customer

As measure:

sum(Sales)

then under adds on; uncheck show zero values

[avinashelite · Accepted solution]

Or try like this

sum({<Sales={">0"}>}Sales)

[Chanty4u]

or

Sum(sales) > 0

[barbora_s]

Hi guys,

thanks a lot. Will try ur answers tonight and mark the answer.

Have a good one!

B.

[zebhashmi]

this one two

sum(if(Sales>0,Sales))