Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to pull data from crosstable

Hi everyone,

I am facing a problem while pulling data from a crosstable. Below table displays maintenance cost for different products per year for Q1 to Q4. This table is present in excel sheet.

2010 2011
ProductQ1Q2Q3Q4Q1Q2Q3Q4
Cycle10006500456058602000450012302450
Bike20004500123024501000650045605860
Car30005000321065802000300050003210
Truck400050045601245300040005004560

I want this data to be pulled in a QVW and dispalyed in below manner.  How to pull data from above kind of tables in a organised way?

Product YearQuarterMaintenance Cost
Cycle2007Q11000
Cycle2007Q26500
Cycle2007Q34560
Cycle2007Q45860
Bike2007Q12000
Bike2007Q24500
Bike2007Q31230
Bike2007Q42450


Thanks,

Amey.

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hei

attach is an example may be you can do somthing similar

what the load script does is rotate the table and then cross table it

View solution in original post

4 Replies
lironbaram
Partner - Master III
Partner - Master III

hei

attach is an example may be you can do somthing similar

what the load script does is rotate the table and then cross table it

Not applicable
Author

Hi Liron,

Thanks a lot it works .

sridhar240784
Creator III
Creator III

Hi,

if i understood your question,this could be done with  QlikView ETL Transform functionality.

Target your file and Say Next to Enabel the Transformation Steps. Then you can play with Transpose and Fill Value in Wizard.

Have a look at the attached application.

Hope this helps you.

-Sridhar

Not applicable
Author

Hi Shridhar,Yes we can achieve it by this method also. But I have a doubt, whether this method will remain useful even for large and uneven cross tables???