topic Missing data values in bar chart in QlikView

Missing data values in bar chart

Tue, 28 Oct 2014 12:35:26 GMT

Hi All,

I'm facing a problem showing only top 5 values on a bar chart with 2 dimensions displayed. In the print screen you will see that I get the same dimension values even if under one is not a part of the top..

The dimension includes the following:

1- Is Recommended

2- Aspect Name

3- =1 a dummy dimension to support the 2 dimensions above to be one on top of the other and not side by side

Thanks for your help!

Hila.

Re: Missing data values in bar chart

Tue, 28 Oct 2014 12:48:44 GMT

Hi,

In the Bar chart properties---> style---> Stacked plz check that you will get as per your requirement

Re: Missing data values in bar chart

Tue, 28 Oct 2014 12:55:12 GMT

Hi Rakesh!

Thanks for your reply!

Since my chart is is oriented on the side the stacked option is grey and I can't select it.

Hila.

Re: Missing data values in bar chart

jpenuliar — Tue, 28 Oct 2014 13:00:04 GMT

Hi,

Have you tried, a Calculated Dimension for your Aspect Name something like

=Aggr(if(rank(count(COUNTER))<=5,[Aspect Name],[Aspect Name])

Re: Missing data values in bar chart

Tue, 28 Oct 2014 13:17:59 GMT

Hi Jonathan!

It's progressing.. Now I don''t get the missing values but I don't get the correct top values..

Thanks for you help!

Hila.