topic Re: Crosstable Load in QlikView

Crosstable Load

tmumaw — Sat, 16 Nov 2024 19:05:10 GMT

I'm trying to build a crosstable and keep getting error on my Load of crosstable. Anyone see anything strange?

Thanks

Thom

Temp2:
Load
Ship_accountid as ShipTo,
ContractStart_Year as Start_YR,
Count(distinct(opportunityid)) as NoOpptunities
Resident Opportunity
Group by Ship_accountid, ContractStart_Year
;
CrossTable (Start_YR,Value,1)
Load
ShipTo
Resident Temp2
;

Re: Crosstable Load

jwjackso — Wed, 19 Feb 2020 20:33:36 GMT

You need to include the fields

CrossTable (Start_YR,Value,1)
Load
ShipTo,

Start_YR,

NoOpptunities
Resident Temp2;
;

Or you could try

Temp2:

CrossTable (Start_YR,Value,1)
Load
Ship_accountid as ShipTo,
ContractStart_Year as Start_YR,
Count(distinct(opportunityid)) as NoOpptunities
Resident Opportunity
Group by Ship_accountid, ContractStart_Year
;

Re: Crosstable Load

tmumaw — Wed, 19 Feb 2020 21:42:45 GMT

This is what I'm seeing:

ShipTo Start_YR Value

12345 Start_YR 2019

12345 NoOpportunities 1

I'm seeing 2 lines and I would like to see 1 line with values

Re: Crosstable Load

jwjackso — Wed, 19 Feb 2020 21:48:32 GMT

A Crosstable converts a row with multiple columns into multiple rows. You might be looking for the Generic Load

Re: Crosstable Load

tmumaw — Wed, 19 Feb 2020 23:42:02 GMT

Looking for examples of generic loads. Does anyone have one to share? Thanks