topic Re: Cross table with repeating dimensions challenge in QlikView

Cross table with repeating dimensions challenge

marcel_olmo — Sun, 19 Nov 2017 19:21:48 GMT

Hi guys,

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.

Re: Cross table with repeating dimensions challenge

sunny_talwar — Sun, 19 Nov 2017 19:54:11 GMT

Try this

CrossTableExample:

CrossTable(Dimension, Number, 5)

LOAD [Customer Id],

[Shipment Id],

[Activity Id],

[SubActivity Id],

[Family Id],

[Amount Jan],

[Units Jan],

[Amount Feb],

[Units Feb]

FROM

ExampleCrossTable.xlsx

(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))

));

Re: Cross table with repeating dimensions challenge

marcel_olmo — Mon, 20 Nov 2017 00:30:39 GMT

Thanka Sunny, that was what I need. Regards, Marcel.