Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Best Way to Structure Data Load in Script

Hi,

I have a table which is arranged as,

FileIDDataIDData

1

0001

01/01/2011

10002500
10003Name
2000105/04/2012
200021200
20003Name2
3000107/06/2010
30002150
30003Name3

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,

FileIDDataID=0001DataID=0002
101/01/2011500
205/04/20121200
307/06/2010150

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

Thanks

1 Solution

Accepted Solutions
jason_michaelid
Honored Contributor II

Re: Best Way to Structure Data Load in Script

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

2 Replies
jason_michaelid
Honored Contributor II

Re: Best Way to Structure Data Load in Script

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

Not applicable

Re: Best Way to Structure Data Load in Script

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

Community Browser