Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks Jason. I was mistakenly under the impression that table items were faster than charts.