6 Replies Latest reply: Mar 21, 2018 3:33 PM by Jahanzeb Hashmi

Show sales > 0

Barbora S Mar 20, 2018 2:40 PM

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!!

Re: Show sales > 0

omar bensalem Mar 20, 2018 4:30 PM (in response to Barbora S)

as dimension:
Customer
As measure:
sum(Sales)

then under adds on; uncheck show zero values
Like Show 0 Likes (0)

Actions
Re: Show sales > 0

Avinash R Mar 21, 2018 3:20 AM (in response to Barbora S)

Or try like this
sum({<Sales={">0"}>}Sales)
Like Show 0 Likes (0)

Actions
Re: Show sales > 0

Chanty 4u Mar 21, 2018 3:25 AM (in response to Barbora S)

or

Sum(sales) > 0
Like Show 0 Likes (0)

Actions
Re: Show sales > 0

Gloria Bertini Mar 21, 2018 5:10 AM (in response to Barbora S)

Maybe you can try something like this
Only({<Sales={">0"}>}Customer)
for the dimension espression
Like Show 0 Likes (0)

Actions
Re: Show sales > 0

Barbora S Mar 21, 2018 5:53 AM (in response to Barbora S)

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

Have a good one!
B.
Like Show 0 Likes (0)

Actions
- Re: Show sales > 0
  
  Jahanzeb Hashmi Mar 21, 2018 3:33 PM (in response to Barbora S)
  
  this one two
  sum(if(Sales>0,Sales))
  
  Like Show 0 Likes (0)
  
  Actions

Go to original post