topic Re: Displaying missing data (NULLs?) in QlikView

Displaying missing data (NULLs?)

haymarketpaul — Fri, 24 Jun 2011 09:15:02 GMT

Hello

QV10 SR2

I have data in the following format per customer...

CCCJOBFUNCTION=06,CCCSPECIALISTAREAS=07 | 11,CCCINDUSTRYSECTOR=01,CCCPREQUALIFIED=05 | 01

DDDJOBFUNCTION=07,DDDSPECIALISTAREAS=01 | 03 | 06 | 09 | 14,DDDINDUSTRYSECTOR=01,DDDPREQUALIFIED=05

MFNJOBFUNCTION=05,MFNSPECIALISTAREAS=02 | 09,MFNPREQUALIFIED=02

CCCJOBFUNCTION=01,CCCSPECIALISTAREAS=04 | 05 | 07,CCCPREQUALIFIED=04

I can get this demographic data into a nice orderly table with the aid of a few Subfield statements and that's fine.

The problem i have is i want to be able to select where a customer has no demographic. For example the last 2 in the example above have no industry sector demographic so i would like to be able to display all customers who have no industry sector.

whilst i can happily display the demographics that customers have i do not know how to display demographics they do not have?

I have attached my qvw which might make things a bit clearer!?

Any ideas greatly appreciated.

Displaying missing data (NULLs?)

kaushiknsolanki — Fri, 24 Jun 2011 09:32:11 GMT

Hi,

Go to properties of pivot you have on sheet6 in your example. Presentation tab. Deselect "Suppress Zero Values.

Hope this is what you want.

Regards,

Kaushik Solanki

Displaying missing data (NULLs?)

haymarketpaul — Fri, 24 Jun 2011 09:46:46 GMT

Thanks for the reply,

Unfortunately that doesn't change anything

see customer...

Daniel Bardow

Displaying missing data (NULLs?)

kaushiknsolanki — Fri, 24 Jun 2011 09:52:44 GMT

Hi,

Can you describe what you want in detail with example and is possible with a sample output table.

Regards,

Kaushik Solanki

Re: Displaying missing data (NULLs?)

Fri, 24 Jun 2011 09:55:19 GMT

Hi,

I don't know, even I have understand you well.

On your Sheet6 in the pivot table, I have on the Properties => Register 2 for every dimension checked "Show all values" without checking "leaving zeros", like you did in "Journal Name". So I can see a "Zero Row".

Maybe you mean that?

Regards

vicky

P.S. Combine it with the idea from Kaushik.solanki and you get lots of values.

Re: Displaying missing data (NULLs?)

haymarketpaul — Fri, 24 Jun 2011 10:25:03 GMT

Thanks for the replies, i'll try and explain a bit better what i need to see/do...

Customers can answer a number of demographic questions. If they don't answer a particular question then there is no data for that customer with regards to that question. The data comes from a 3rd party.

I think i need to LOAD a table that as well as holding all the data for the questions they have answered (easy because i have that data) will also need to hold NULLs for the ones they haven't so i can then select these within the dashboard.

My problem is i am not sure how to display the questions the customer hasn't answered as i do not have that data (see my original post for the data that i receive e.g. the last 2 rows have no Industry Sector data because the customer did not answer that question)

I've attached a small spreadsheet of what i would like to see.