topic Re: Bar Chart-Urgent in QlikView

Bar Chart-Urgent

Anonymous — Sun, 31 Aug 2014 12:23:59 GMT

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

Re: Bar Chart-Urgent

ashfaq_haseeb — Sun, 31 Aug 2014 12:59:16 GMT

Hi,

Can you post sample app.

Regards

ASHFAQ

Re: Bar Chart-Urgent

mrooney — Sun, 31 Aug 2014 13:04:02 GMT

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.

Re: Bar Chart-Urgent

nagaiank — Sun, 31 Aug 2014 13:13:06 GMT

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.

Re: Bar Chart-Urgent

Anonymous — Sun, 31 Aug 2014 13:18:29 GMT

Hi NagainK,

Its not giving the expected output.

Re: Bar Chart-Urgent

jagan — Sun, 31 Aug 2014 14:29:35 GMT

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.