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..
-->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
create variables for 4 expressions and write
so that it will show only Not null values.
correct me if i muss understand your query