topic Re: Converting Xls into Qlikview readable format in QlikView

Converting Xls into Qlikview readable format

Sun, 23 Aug 2015 04:46:44 GMT

I am trying to convert this table in to a qlikview readable format. I have to upload this in the QVW and convert into qvd or csv. Please, help me with this.

Re: Converting Xls into Qlikview readable format

petter — Sun, 23 Aug 2015 05:34:53 GMT

The data can be brought into QlikView in a number of ways with a Load Script.

To be able to give you sound advice you need to tell us how you really need the data to be in the QVD or CSV format file(s). Can you leave it exactly like it is in Excel or do you need to transform it in any way?

1) It could be read as is - which means that the structure of the data is unchanged from this report oriented format. This is rather unpractical if you want to do some analysis or further enrichment of the data from other sources.

2) You can restructure the data as it is read in the load script so it turns into a more optimal format for analysis and building an application.

Then the most convenient way is to change the month columns into rows by using a CROSSTABLE LOAD to

"unpivot" the columns into more rows.

Since these are multiple tables using multiple CROSSTABLE LOAD statements would be necessary to get all of the data in correctly.

You can use the LOAD SCRIPT editor and the Table Files wizard to bring in the data this way.

3) You can use one or more STORE statements at the end of the load script to produce either CSV-files or QVD-files.

Re: Converting Xls into Qlikview readable format

alibd225 — Sun, 23 Aug 2015 10:40:33 GMT

you have to click Enable Transformation Step...

and load crosstable script after your necessary step

CrossTable(PaperName, Quantity, 2)

LOAD * FROM

[Test.xls]

(biff, embedded labels, table is Day_1$, filters(

Remove(Row, RowCnd(CellValue, 1, StrCnd(null))),

Remove(Row, RowCnd(CellValue, 1, StrCnd(equal, 'Total'))),

Remove(Row, Pos(Top, 1)),

Remove(Col, Pos(Top, 1))

));

Re: Converting Xls into Qlikview readable format

Kushal_Chawda — Sun, 23 Aug 2015 10:47:40 GMT

How you want to transform the data?

Do you want to load the data as it is like excel?

What will be the expected output you need?

Provide sample excel also to work on it

Re: Converting Xls into Qlikview readable format

Sun, 06 Sep 2015 05:41:16 GMT

Thank you everyone. Cross table functionality helped me achieve the desired result.

Re: Converting Xls into Qlikview readable format

petter — Sun, 06 Sep 2015 07:41:46 GMT

You are welcome

Please close this thread by marking it as answered on the most "correct" suggestion. It is also nice to mark some suggestions or hints as helpful.

Re: Converting Xls into Qlikview readable format

qlikviewwizard — Sun, 06 Sep 2015 07:56:17 GMT

Hi Dilip,

Please close the thread by selecting Helpful/Correct Answer. Thank you.