Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Honored Contributor II

Re: How to pull data from crosstable

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

4 Replies
lironbaram
Honored Contributor II

Re: How to pull data from crosstable

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

Re: How to pull data from crosstable

Hi Liron,

Thanks a lot it works .

sridhar240784
Contributor III

Re: How to pull data from crosstable

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

Re: How to pull data from crosstable

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???