Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

barbora_s
New Contributor

Show sales > 0

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.

CustomerSales
X1
Y0
X2
Z1
Y0
W0

Thanks!!

B.

Tags (1)
5 Replies
OmarBenSalem
Esteemed Contributor

Re: Show sales > 0

as dimension:

Customer

As measure:

sum(Sales)

then under adds on; uncheck show zero values

Re: Show sales > 0

Or try like this

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

sureshqv
Esteemed Contributor III

Re: Show sales > 0

or

Sum(sales) > 0

barbora_s
New Contributor

Re: Show sales > 0

Hi guys,

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

Have a good one!

B.

zebhashmi
Valued Contributor

Re: Show sales > 0

this one two

sum(if(Sales>0,Sales))

Community Browser