topic Need help with Applymap and Crosstable in QlikView

Need help with Applymap and Crosstable

Tue, 17 Jul 2012 22:26:48 GMT

Need help here folks. I have followed instructions exactly and getting failures. Here is script:

Rollup:

LOAD *

;

SELECT

[TestVar],

[Rolls Up To]

from X

;

TEST:

CrossTable(TestVar, Value, 1)

LOAD *

;

SELECT

[y1],

[y2]

;

Final:

LOAD *

, ApplyMap('Rollup', TestVar)

RESIDENT TEST

;

DROP TEST

It looks like it finishes and then it goes back to the home screen and it says it failed to load. What a nightmare.

Anonymous — Tue, 17 Jul 2012 23:55:22 GMT

Some fixing and cleaning is needed:

Rollup:
MAPPING SELECT DISTINCT
[TestVar] as A,
[Rolls Up To] as B
from X
;

TEST:
CrossTable(TestVar, Value, 1)
LOAD
        ,
        [y1],
        [y2]
;
SELECT
        ,
        [y1],
        [y2]
;

Final:
LOAD *
, ApplyMap('Rollup', TestVar) as NewField

;

DROP TABLE TEST;

Hope i didn't miss anything essential...

Regards,

Michael