Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help with Applymap and Crosstable

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. 

1 Reply
Anonymous
Not applicable
Author

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