Did you ever get a response? I have a similar problem, 2 years later.
How do I write an efficient script that pulls multiple dimensions into a cross table, separately:
Customer ID Region Jan Cost Jan Volume Feb Cost Feb Volume
I'd like to have cost and volume broken out as separate fields. Any advice would be much appreciated.
Right now the only way I can think of is to load the same raw data file twice, and comment out the cost or volume fields in each one. This obviously results in inefficiencies when loading, and a syn-riddled data model.
Thanks! Was hoping for a more elegant solution than this, especially since this problem appears to have been making the rounds on Qlikview forums for some time now. Does anyone have a simpler solution?
