Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

balrajahlawat
Esteemed Contributor

Suppressing Zero value for an expression in Qliksense

Hey Qlikers,

I am having a bar chart with one dimension and four expression(Say Exp1, Exp2, Exp3, Exp4) which shows Last 4 week and Prev Qtr value comparison.

Exp1 is for Prev Qtr Ending Date Value only ...which is not related to any of the last 4 week date.....

Now in Qliksense bar chart,  Exp1 is showing '0' value as Exp1 along with rest of the expression...I want to exclude this expression for last 4 week date as it shows only Prev Qtr Value.....

Pls suggest, how I can do it...

Let me know if you need more info..

Regards,

BA


1 Reply
ramasaisaksoft
Valued Contributor III

Re: Suppressing Zero value for an expression in Qliksense

Hi Balaraj,

Way 1:-

-->instead of writing expression in chart ,

-->you can create a dimension for your expression, in Script itself .

-->you can call that dimension

-->select the check box Exclude Null values


Way 2:-

create variables for 4 expressions and write

if($(vexp1)>0,vexp1)

so that  it will show only Not null values.

correct me if i muss understand your query