Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hie Experts
I'm new to Qlikview, I'm having problems trying to load a cross-table into Qlikview and my file is an excel file. The file has three header columns and also dates on top.I have uploaded the file above, if you can show me how to do it, and also is there a smart way to handle dates in Qlikview.
You can post the script for me,because I'm using a personal edition Qlikview so I wont be able to open qvw.
You want to show same thing in qlikview.
I think this link (Loading Cross Tables) will give you what you need. It is a video on loading crosstables.
Also, here is the script as this link has a qvw that you will not be able to load.
CrossTable(Quarter, Sales)
LOAD [Sales Rep],
[Q1 2010],
[Q2 2010],
[Q3 2010],
[Q4 2010],
[Q1 2011],
[Q2 2011],
[Q3 2011],
[Q4 2011],
[Q1 2012],
[Q2 2012],
[Q3 2012],
[Q4 2012]
FROM
[Data.xlsx]
(ooxml, embedded labels, table is Sheet1, filters(
Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'Total'))),
Replace(1, top, StrCnd(null))
));
Here are the results in the qvw:
Hope this works for you!
- Stan
Hi Anil babu,sorry for the late response,Yes i want to show the same thing in Qlikview.
Hi Stan Bennett
Thank you for the link to the video,but thats not what Im looking for,because the excel file has three headers whereas the video i just showing the basic with one header column
can you please post the sample data and script from this QVW.
inside the zip file you will find a qvs (scriptfile )file which you can use in your qvw.
or you open this file with an editor and paste the content to your script.
hope this helps
Did you find a solution to load a multi header excel file ?