topic Re: Excel Data Transformation in QlikView

Excel Data Transformation

agni_gold — Sat, 31 May 2014 21:11:30 GMT

I have a problem related to data transformation

I am attaching my excel sheet in this sheet 1 contains source data and sheet2 contains as i want to transform , how can i do this

I have tried cross table but it gives sum for perticular date.

Please help how can i do that .

Re: Excel Data Transformation

fkeuroglian — Sat, 31 May 2014 21:51:27 GMT

Hi, try to use CROSS TABLE in qlikview

see this link and example

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

http://www.learnqlickview.com/cross-table-in-qlikview/

good luck

Fernando

Re: Excel Data Transformation

Anonymous — Sat, 31 May 2014 22:01:23 GMT

Hello!

First you need to exclude the blank lines, then transpose the table, and last use crosstable. Attached is a qvw that transforms the data the way you want. Hope it helps.

Regards.