topic Re: Remove blank space between the missing values in a bar chart in QlikView

Remove blank space between the missing values in a bar chart

Wed, 21 Jan 2015 17:31:46 GMT

hi all,

I trying to build a bar chart with 2 dimensions and counting IDs, the requirement is to not show the empty space in bar chart if value is missing,

attached are the screen shot of the data and bar chart.

thank you in advance.

NickHoff — Wed, 21 Jan 2015 17:48:09 GMT

On the presentation tab make sure Suppress Zero-Values and Suppress Missing is checked.

Wed, 21 Jan 2015 18:10:19 GMT

hi Nick ,

the options are check marked in presentation tab but its not working.

NickHoff — Wed, 21 Jan 2015 18:15:01 GMT

If that is the case then the fields aren't actually null or missing then it's an issue with how you are building the table.

sujeetsingh — Wed, 21 Jan 2015 18:20:12 GMT

I will suggest you to use the Stacked style of the chart

Anonymous — Wed, 21 Jan 2015 18:37:20 GMT

You cannot. But you can use pivot table with colors - see attached.

ashwanin — Wed, 21 Jan 2015 19:24:08 GMT

Hi Sanket,

I don't think its possible .but if you do a little change in the bar chart, then it will not reflect your blank field ref Qvw.

saurabh5 — Thu, 29 Jan 2015 16:26:31 GMT

hi Sanket,

if you dont want to use sttacked bar chart, there is a work around, if you seperate out your home type dimenssion into 3 different fields like:

if(hometyp='A',1,0) as HometypA,

if(hometyp='B',1,0) as HometypB,

if(hometyp='C',1,0) as HometypC,

and then create 3 graphs with calculated dimenssion similar as shown below

=if(HometypA='1',hometyp)

and put these graphs in a container object while suppressing null values it will remove the blank space.