How to hide nulls caused by second dimension

[varunreddy]

Hi Guys,

I am trying to create a bar graph with 3 dimensions.

In this graph the first dimension has 2 values (i.e. Individual and Organisation).

Here second dimension is shown for both the values though there is no association. I want to hide/delete the non-associated values of second dimension from 1st.

Is there a way we can do it?

I am also attaching the QVW file and data file for reference.

Can anyone help me with this?

Screenshot of data file:

Thanks in advance!

Regards,

Varun

[maksim_senin]

Hi Varun,

I found this quite long time ago - the reason is that the second demension is visit whilst it has a value in any other dimension of the first level.

Try removing values from, e.g. City at all and you will see it.

Best regards,

Maxim.

[varunreddy]

Hi Senin,

Thanks for the response. Can you elloborate, what exactly removing value is?

Regards,

Varun

[maksim_senin]

Just put zeros next to City or just remove rows with City from Excel-file and update your QVW. After the City what have voule in both volues of first dimension.

[avinashelite]

Did you tried Suppress null in the dimension tab for the second dimension

[varunreddy]

Yes. But the result is still same

[varunreddy]

Senin,

For Individual I have 3 values (DOB, ID and Phone Number)

For Organisation I have 3 values (City, Name and Region).

So I cannot remove rows.

[maksim_senin]

Hi Varun,

As far as you have a value in City (or other dimension) your bar char with more then one dimensions on of which is the City will not hide empty values. It seems it works as designed. At the same time straight table hides the empty values.

So my conclusion is - there is no way to hide empty values in your case.

Best regards,

Maxim