Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to condition a simple expression

Hello,

I am sure this is a silly-easy question but I am new and learning to please be patient :

I have the following expression in a Pivot Table Chart with Sales and Day\Month\Year dimensions (among others) : 


Sum (sales) - Above (Sum (Sales))

How Can I add a condition that when sum (sales) = 0  than  either show an error or do not show any value for the expression in the Chart

(Since when Sum can not be zero, it indicate the data was not loaded in that Date)

(Sum (sales) - Above (Sum (Sales)))

Thank

Nir 

1 Solution

Accepted Solutions

Re: How to condition a simple expression

Something like.

If(Sum (sales) - Above (Sum (Sales))<>0, Sum (sales) - Above (Sum (Sales)), 'Not Avail.')

2 Replies

Re: How to condition a simple expression

Something like.

If(Sum (sales) - Above (Sum (Sales))<>0, Sum (sales) - Above (Sum (Sales)), 'Not Avail.')

Re: How to condition a simple expression

May be this:

If(Sum(sales) <> 0, Sum(sales) - Above(Sum(Sales)))

Community Browser