Discussion Board for collaboration on QlikView Scripting.
How to concat 2 cross tables????
if you load
two cross table then it will automatcally concatenated
if you want then use concatenate in between two tables
Create both Cross Tables seperately and the concatenate it
I was wondering if you've already solved the problem. I got the same problem as well. Got a few cross tables and i'm not able to concatenate them.
My colleague found the answer:
Load the cross tables into another tab.
LOAD *, 'ScoreDB' AS Transactietype Resident ScoreDB; Concatenate(Transacties) LOAD *, 'ScoreCrit' AS Transactietype Resident ScoreCrit; Concatenate (Transacties)
Drop table ScoreDB; Drop Table ScoreCrit;
This worked for me.
f you load two table with same structure then it will automatically concatenated
else you need to force fully concatenate like
I tried it as well but that didn't work with cross tables. In my case it didn’t concatenate automatically. After I loaded the cross table again I was able to concatenate the tables.