Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

markgraham123
Contributor II

Sub category in Bar chart

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.

Tags (2)
5 Replies
hrlinder
Honored Contributor

Re: Sub category in Bar chart

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
Contributor II

Re: Sub category in Bar chart

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
Contributor II

Re: Sub category in Bar chart

qvtest pic.png

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.

hrlinder
Honored Contributor

Re: Sub category in Bar chart

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
Contributor II

Re: Sub category in Bar chart

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.

Community Browser