topic Pivot Table - Showing missing data... in QlikView

Pivot Table - Showing missing data...

Thu, 28 Jun 2012 10:21:42 GMT

Hi, I've been tasked with putting a view together for our key accounts in our business. they want to use this to additionally highlight business which traded in the previous year and has done nothing in the current year. all easy so far, but the way they want this displayed is they if they have given us a particular job type in 2011 & nothing in 2012 they want 2011 figures and then 2012 blank... I've tried showing all values etc but doesnt seem to give the desired effect.

also as an extra problem, if they've given us a courier job in 2011 and nothing in 2012 but have never given us export work then i dont want Export 2011 and 2012 with both blank.

Any help much appreciated, as not 100% sure where else to go with this. i think i'm trying to get a pivot table to do something that its not designed to do...

i've attached an example of the data, AAL0095 gave us Export in 2011, nothing in 2012..

Re: Pivot Table - Showing missing data...

giakoum — Thu, 28 Jun 2012 10:29:14 GMT

try to populate the list with zero values during load.

Something like :

LOAD

customerid,

jobtype,

year,

month,

0 as jobs

and concatenate it with your original table.

Re: Pivot Table - Showing missing data...

Thu, 28 Jun 2012 10:52:52 GMT

Hi, thanks for the suggestion, i've tried putting another arguement into the load to do what youve suggested above, but doesnt seem to work errors due to duplicate field names, the current load is bringing the data in from 6 different tables, two each for Export, Import & Courier...

Re: Pivot Table - Showing missing data...

Fri, 29 Jun 2012 09:41:16 GMT

Hi,

Can you provide the sample qvw with some dummy data.