Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nenadvukovic
Creator III
Creator III

CrossTable is not enough, as far as I know. Do you know?

Hi,

If you have a table structured like this:

                         P1      P1      P2      P2

Customer      Volume Price Volume Price

ABC                100      10      200      11

DEF                300      20      400      21

using the CrossTable function, I can't get this:

Customer      Period     Volume Price

ABC                P1          100      10

ABC                P1          200      11

DEF                P2          300      20

DEF                P2          400      21

Thanks a lot

I get two unexpected rows and incorrect Price:

2018-06-23_12-01-55.jpg

2018-06-23_12-02-48.jpg

Message was edited by: Nenad Vuković

17 Replies
sunny_talwar

May be check this out

multi_header_pivot_import.qvw

sunny_talwar

PFA the sample script

Capture.PNG

nenadvukovic
Creator III
Creator III
Author

Thanks Sunny. My original table has this structure:

2018-06-22_16-30-25.jpg

I need first 9 dimensions to be available. Next 3 I ignore and then read values for 12 x 2 columns (Volume and Price).

Do I need to modify the provided script to handle this structure?

Thank you

sunny_talwar

Change here

Capture.PNG

Add all the dimensions you need.

And add all the dimension here

Capture.PNG

nenadvukovic
Creator III
Creator III
Author

Yes, I realized that in the meantime. Thank you very much.

nenadvukovic
Creator III
Creator III
Author

Hi Sunny,

Can you please take a look into the updated initial post as I am getting strange results. Thx

sunny_talwar

May be share your Excel file here for us to test

nenadvukovic
Creator III
Creator III
Author

Thanks for looking into this.

You can find a few lines in the attached file.

sunny_talwar

See if this works