Solved: Linearization of the data - Qlik Community

tizianacaem · ‎2010-09-23

Hi all,

I have a problem with the linearization of the data.
I have a table that contains records consisting of: Item, Period(year, month) and 31 columns (one for each day of the month) with the value of the daily stock.
I need a way to turn any records in to 31 records, so that each record contains a single value of daily stock.
Anyone have any ideas?

Thank you

Tiziana

see you the exemple attached.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3581.ESEMPLE.xls:550:0]

renjithpl · ‎2010-09-23

Hi Tiziana,

If i understood your question,

i have a solution for this, Load your data and use crosstable with qualifier fields 2, give the attribute name as Day, and Data name as Data or whatever you want it.

Then use a straight table. you will get the data how you want it.

Thanks

View solution in original post

renjithpl · ‎2010-09-23

Hi Tiziana,

If i understood your question,

i have a solution for this, Load your data and use crosstable with qualifier fields 2, give the attribute name as Day, and Data name as Data or whatever you want it.

Then use a straight table. you will get the data how you want it.

Thanks

tizianacaem · ‎2010-09-23

Is just what I was looking!!

Thank you Rerenjithpl.