Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to add a condition to get rid of zero amount using a variable

Hi

I am trying to eliminate the zero values in my expression,(so that all the consultants with 0 debts do not get displayed in my table) using the variable that i have created,i tried:

 

 

 

=

Thanks in advance.

if($(vActiveDebt)>0,
$(vActiveDebt),0)

1 Solution

Accepted Solutions
aadilmadarveet
Valued Contributor

Re: How to add a condition to get rid of zero amount using a variable

dont keep the "0" in the else part of the IF condition.

if($(vActiveDebt)>0,$(vActiveDebt))

alternatively, you can suppress the zero's by checking the Suppress Zero Values option in the Presentation tab.

6 Replies
aadilmadarveet
Valued Contributor

Re: How to add a condition to get rid of zero amount using a variable

dont keep the "0" in the else part of the IF condition.

if($(vActiveDebt)>0,$(vActiveDebt))

alternatively, you can suppress the zero's by checking the Suppress Zero Values option in the Presentation tab.

Not applicable

Re: How to add a condition to get rid of zero amount using a variable

Hi

It does show other values which are > 0 but the 0 ones appears as follows:

ConsultantName           DebtAMount

xxxxxx                             -

yyyyyy                             -

I did tick the suppress zero-value on the presentation tab. 

jsn
Honored Contributor

Re: How to add a condition to get rid of zero amount using a variable

Try checking "Supress when value is null" on the dimension tab.

MVP
MVP

Re: How to add a condition to get rid of zero amount using a variable

Are you showing other expressions, that do evaluate to <> zero? 'Suppress zero values' only works on lines where all expressions evaluate to zero. Use conditionals on the other expressions to set them to zero, too, if possible.

Not applicable

Re: How to add a condition to get rid of zero amount using a variable

Hi Johannes

In this case the dimension is not null.What i suspect is that qlikview does not recognise my variable as a number,that is why the suppress zero value does not work ,how can i rather convert this into a number?

Thanks.

Not applicable

Re: How to add a condition to get rid of zero amount using a variable

Hi swuehl

You are so right.I took out other expressions and it worked.

Thanks a lot guys.

Community Browser