Displaying missing data (NULLs?)

[haymarketpaul]

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.

[kaushiknsolanki]

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

[haymarketpaul]

Hi

Thanks for the reply,

Unfortunately that doesn't change anything

see customer...

Daniel Bardow

[kaushiknsolanki]

Hi,

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

Regards,

Kaushik Solanki

[#5]

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.

[haymarketpaul]

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.