Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 

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



1 Reply

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


so that  it will show only Not null values.

correct me if i muss understand your query