Data optimization suggestion needed?

Fri, 01 Jun 2012 10:42:54 GMT

Hi All,

I have some stock chart related data. The customer has provided me the data in the following format

HigherClose1, Hhigh1, HLow1,..........HigherClose2,HHigh2, HLow2.................. etc

The summary has to be shown in the following Pivot chart format

Bar1 Bar2 Bar3......................................................Bar30

HigherClose

Hhigh

HLow

HigherClose1, Hhigh1, HLow1 belongs to Bar1, and HigherClose2,HHigh2, HLow2 belongs to Bar2 and so on

I have done a small tweak to the orginal table. I have unioned all the columns into one column BarValue (Contains all the values from HigherClose1, HigherClose2, Hhigh1, Hhigh2 etc). The other two columns identify the number and type of Bar

BarValue BarNumber BarType

0.567 Bar1 HigherClose

...... Bar1 Hhigh

......... Bar1 Hlow

........ Bar2 HigherClose

........ Bar2 Hhigh

I have merged them into a single column because it is easy to create a pivot chart this way. I use the BarNumber and BarType in dimension, and use the BarValue in expression

Now the problem is that the rows grow by 342, as the total columns are 342. If I have 15 million rows, then you can see the data grows by a lot. Can someone suggest any other method, where I can achieve the same purpose but the rows do not grow so much

Regards

Syed

topic Data optimization suggestion needed? in QlikView

Data optimization suggestion needed?