Discussion Board for collaboration on QlikView Scripting.
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.
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?
Go to Solution.
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
Thanks a lot it works .
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.
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???