Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Crosstable Load

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
;

Labels (1)
1 Solution

Accepted Solutions
jwjackso
Specialist II
Specialist II

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

View solution in original post

4 Replies
jwjackso
Specialist II
Specialist II

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
;

tmumaw
Specialist II
Specialist II
Author

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

 
 

 

jwjackso
Specialist II
Specialist II

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

View solution in original post

tmumaw
Specialist II
Specialist II
Author

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