5 Replies Latest reply: Jun 24, 2011 6:25 AM by Paul Nockolds RSS

    Displaying missing data (NULLs?)

    Paul Nockolds

      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?)
          Kaushik Solanki

          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

          • Re: Displaying missing data (NULLs?)
            Paul Nockolds

            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.