Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Cross table with repeating dimensions challenge

Hi guys,

I have to read a bunch of excels with a format like this :

Ex1.png

If I do a regular cross table, this is my result :

ex2.png

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.

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Cross table with repeating dimensions challenge

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(3, top, StrCnd(null)),

Replace(4, top, StrCnd(null))

));

View solution in original post

2 Replies
Highlighted

Re: Cross table with repeating dimensions challenge

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(3, top, StrCnd(null)),

Replace(4, top, StrCnd(null))

));

View solution in original post

Highlighted
Partner
Partner

Re: Cross table with repeating dimensions challenge

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