Exclude Zero bars

[New-Qlik]

HI ,

I have a requirement to exclude zero bar form a bar chart.

I have two dim and one exprsssion bar chart.

For dim who has no entry wrt to count are also coming in bar chart  just name on axis.

how can I exclude this.

I have tried all supress zero, null etc nothing working

[MK_QSL]

Script

Data:

LOAD

  Dim1,

  Dim2,

  Sales,

  Dual(Dim1 & chr(10) & Dim2, autonumber(Dim1) & Ord(Dim2)) as TempDim1

Inline

[

Dim1, Dim2, Sales

2001,Jan,100

2001,Feb,150

2002,Jan,200

2002,Mar,100

2003,Jan,250

2003,Apr,400

2004,May,150

2004,Jun,350

];

Concatenate

LOAD Distinct

  Dim1,

  'Z1' as Dim2,

  Dual('', AutoNumber(Dim1) & Ord('Z')) as TempDim1,

  '0' as Sales

Resident Data;

Bar Chart

Dimension

=Aggr(TempDim1, Dim1, Dim2)

Tick Suppress When Value is Null

Expression

SUM(Sales)

[Anil_Babu_Samineni]

Manish Bhai, Why do we need Concatenate Table? Without Table we can achieve, right?

[New-Qlik]

ok I missed something

1. I have three dimen

2. my expression is count(status)

now if I assign '0' as Status it is coming in legend also like status closed, opem and 0

I can exclude it but now sure howz this behaving.

Manish can u share your app the test one only.

[Anil_Babu_Samineni]

You can use same Manish recommend

[MK_QSL]

loveisfail

Concatenate is better option as we shouldn't keep separate table only for few lines. Performance would be better with concatenating them.

avneet85

Better you provide your application, along with the output you needed in excel file. We will work on it.

[MK_QSL]

Not a good idea to use three dimensions on x axis. As a rule, when you have 3 dimensions, you should show chart as two dimensions on x axis with stacked chart based on 3rd dimension values and 3 rd dimension as legend.

[New-Qlik]

Can u please share Qvw for same

[New-Qlik]

ok let me create one same app as replica , will share soon

[kamal_sanguri]

I understand your concern although mrkachhiaimp‌ has given a possible solution. Still you can think of changing a chart type.

Use of Block chart instead of Bar will solve your problem.

[New-Qlik]

Hi Please find attached sample application