Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

manish_madan
New Contributor III

Bar Chart-Urgent

Hi,

I Have a Horizontal Stacked Bar chart with 2 dim and 4 expressions.

Dimensions: 1)KPI

                    2)Zone

Expression are Count of employees(with filter)/ count(All employees)

When i am unticking the KPI Suppress when value is NULL it is solving my purpose but i am getting extra KPI in the end looks like '-'.

Need help to either avoid the KPI named '-' or any other method which we can use.

Thanks

Manish Madan

5 Replies

Re: Bar Chart-Urgent

Hi,

Can you post sample app.

Regards

ASHFAQ

mrooney
New Contributor III

Re: Bar Chart-Urgent

Why do you untick "supress vaelue when is null"?

If you need to manitain this then you need to avoid null values for this domension in script. Perhaps you can use a wehre cause to prevent them to be loaded.

nagaiank
Valued Contributor III

Re: Bar Chart-Urgent

Set the Total Mode to No Totals in the Expressions tab.

If this is grayed out, change the chart type in the General tab to Straight Table and then change the Total Mode to No Totals. You may change the chart type to Bar chart after this.

manish_madan
New Contributor III

Re: Bar Chart-Urgent

Hi NagainK,

Its not giving the expected output.

MVP
MVP

Re: Bar Chart-Urgent

Hi Manish,

- is a null values, some employees are not linked to KPI, that's why you are gettting -.  If you dont want to see that then you should select Suppress Null Values in Presentation or Dimension tab. 

Regards,

Jagan.

Community Browser