Discussion Board for collaboration related to QlikView App Development.
I have to read a bunch of excels with a format like this :
If I do a regular cross table, this is my result :
And I'd like to get the same result but with the main dimensions (Customer Id, Shipment Id, Activity Id and Subactivity Id) filled. How could I do this?
I've attached a little example of what I'm trying to do above.
Best regards, Marcel.
CrossTable(Dimension, Number, 5)
LOAD [Customer Id],
(ooxml, embedded labels, table is Hoja1, filters(
Replace(1, top, StrCnd(null)),
Replace(2, top, StrCnd(null)),
Replace(3, top, StrCnd(null)),
Replace(4, top, StrCnd(null))
View solution in original post
Thanka Sunny, that was what I need. Regards, Marcel.