topic Re: How to hide nulls caused by second dimension in QlikView

How to hide nulls caused by second dimension

varunreddy — Fri, 01 Jul 2016 01:52:57 GMT

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

Re: How to hide nulls caused by second dimension

maksim_senin — Fri, 01 Jul 2016 04:12:09 GMT

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.

Re: How to hide nulls caused by second dimension

varunreddy — Fri, 01 Jul 2016 04:18:52 GMT

Hi Senin,

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

Regards,

Varun

Re: How to hide nulls caused by second dimension

maksim_senin — Fri, 01 Jul 2016 06:14:42 GMT

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.

Re: How to hide nulls caused by second dimension

avinashelite — Fri, 01 Jul 2016 06:16:09 GMT

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

Re: How to hide nulls caused by second dimension

varunreddy — Fri, 01 Jul 2016 14:24:24 GMT

Yes. But the result is still same

Re: How to hide nulls caused by second dimension

varunreddy — Fri, 01 Jul 2016 14:26:07 GMT

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.

Re: How to hide nulls caused by second dimension

maksim_senin — Wed, 06 Jul 2016 22:56:31 GMT

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