topic Re: Best Way to Structure Data Load in Script in QlikView

Best Way to Structure Data Load in Script

Wed, 15 Aug 2012 11:06:21 GMT

Hi,

I have a table which is arranged as,

FileID	DataID	Data
1	0001	01/01/2011
1	0002	500
1	0003	Name
2	0001	05/04/2012
2	0002	1200
2	0003	Name2
3	0001	07/06/2010
3	0002	150
3	0003	Name3

I'd like to be able to use tables in the application instead of pivot charts so that calculation times are kept low.

I'd like to arrange the table like this,

FileID	DataID=0001	DataID=0002
1	01/01/2011	500
2	05/04/2012	1200
3	07/06/2010	150

What's the best way of structuring this so that it's formatted this way in the script?

Thanks

Re: Best Way to Structure Data Load in Script

Jason_Michaelides — Wed, 15 Aug 2012 11:36:17 GMT

Generally, tall thin tables like your top sample perform better in QlikView than your transformed requirement. Also, table objects are MUCH slower than charts (or did you mean a straight table chart?).

I'd leave it as it is and use set analysis or DataID selections to control whats shown in the charts.

Hope this helps,

Jason

Re: Best Way to Structure Data Load in Script

Wed, 15 Aug 2012 12:35:08 GMT

Thanks Jason. I was mistakenly under the impression that table items were faster than charts.