topic Re: Sub category in Bar chart in QlikView

Sub category in Bar chart

markgraham123 — Thu, 20 Aug 2015 14:32:21 GMT

Hi all,

I'm working on a req. where i need to display a bar chart.

In the bar chart, i'm displaying the names on X-axis and Utilization as expression.

Here, i have sub categories for only two names.

I wanna show the sub categories for the ones which exists.

can some one pls look into this.

Any help is greatly appreciated.

Anonymous — Thu, 20 Aug 2015 14:35:42 GMT

if i understand corect:

just got o Dimension Zone and set "suppress when value is null"

and check if in tab presenation "suppress Zero values" also is set

markgraham123 — Thu, 20 Aug 2015 14:40:14 GMT

But, its removing the names which doesn't have zone.

I still want to display the names with out zone and names which have zone as a sub category

markgraham123 — Thu, 20 Aug 2015 14:45:29 GMT

As u can see, it still shows that there is no zone for Name 'D'.

I wanna remove displaying for Zone, which doesn't have it but display the general info.

Anonymous — Thu, 20 Aug 2015 14:51:32 GMT

so you want those names without zones to be closer (no bar for zones

as there is no value?)

This won't work

Or what is your expected Chart?

markgraham123 — Thu, 20 Aug 2015 14:53:26 GMT

My expected chart is ..

I wanna show the available values for those which doesn't have Zone.

For the only names which have Zone, i wanna show the sub category 'Zone' in it.