Discussion Board for collaboration on QlikView Layout & Visualizations.
I Have a Horizontal Stacked Bar chart with 2 dim and 4 expressions.
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.
Can you post sample app.
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.
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.
Its not giving the expected output.
- 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.