topic Extra data with crosstable in QlikView

Extra data with crosstable

Anonymous — Mon, 04 Nov 2013 12:35:31 GMT

I have Crosstable() that works fine :

/////////////////////////////////////////////////////////////////////////

DQD :

/////////////////////////////////////////////////////////////////////////

CrossTable( [Flag Name], [Value] ,1)

load

[Flight ID] ,

[First Bag Missing Data Flag] as [First Bag Missing Data] ,

[Last Bag Missing Data Flag] as [Last Bag Missing Data]

resident Data.Quality

;

But............. there are some extra dimension fields in the Data.Quality table that I would like included in the DQD table.

Any suggestions how to do it without re-loading the DQD table ?

Best Regards, Bill

Re: Extra data with crosstable

fred_s — Mon, 04 Nov 2013 12:41:40 GMT

Hi Bill,

What's wrong with reloading Data.Quality?
You're already loading from resident.

/////////////////////////////////////////////////////////////////////////
DQD :
/////////////////////////////////////////////////////////////////////////
CrossTable( [Flag Name], [Value] ,1)
load
[Flight ID] ,
[First Bag Missing Data Flag] as [First Bag Missing Data] ,
[Last Bag Missing Data Flag] as [Last Bag Missing Data]
resident Data.Quality
;

left join
Load [Flight ID],
ExtraDim1,
ExtraDim2
resident Data.Quality
;

Re: Extra data with crosstable

Gysbert_Wassenaar — Mon, 04 Nov 2013 12:41:59 GMT

Put the extra fields in front of the fields that should be pivoted and increase the last parameter to the number of columns that shouldn't be modified

/////////////////////////////////////////////////////////////////////////

DQD :

/////////////////////////////////////////////////////////////////////////

CrossTable( [Flag Name], [Value] ,4)

load

ExtraField1, ExtraField2, ExtraField3,

[Flight ID] ,

[First Bag Missing Data Flag] as [First Bag Missing Data] ,

[Last Bag Missing Data Flag] as [Last Bag Missing Data]

resident Data.Quality

Re: Extra data with crosstable

Anonymous — Mon, 04 Nov 2013 12:48:52 GMT

Brilliant - works perfectly.

I was wondering earlier what that third numeric parameter did, thanks to you I now know.

Many Thanks, Bill