Concatenate with a CrossTable?

Thu, 04 Jun 2015 13:39:44 GMT

Hello,

I'm very new to qlik, but my searches haven't helped, so here's my first question...

I have a excel table with two qualifier fields in columns A & B, then additional columns with same column headings setup time & run time for 10 total operations.

What I want is to have the A& B columns repeated with each operation times as shown below - I thought I'd need a Cross table with concatenate? The additional columns are named the same, how can I tell qlik that I want the concatenate to grab the 2nd, 3rd, etc columns?

Date Planned Setup Run

8-1-14 450 5 30

8-1-14 450 10 60

8-2-14 0

8-3-14 0

8-4-14 450 2 30

8-4-14 450 5 60

If I can get through this part, I'll want to loop this through several sheets with the same setup, if anyone has a suggestion for that as well.

Thanks so much!

Re: Concatenate with a CrossTable?

Gysbert_Wassenaar — Thu, 04 Jun 2015 15:31:56 GMT

Perhaps you can use this qlikview app to load your data: multi_header_pivot_import.qvw

Re: Concatenate with a CrossTable?

Thu, 04 Jun 2015 20:28:27 GMT

This sounds promising, however I don't have a license for QV - I cannot open this file - I'll look into getting my license.

topic Re: Concatenate with a CrossTable? in QlikView

Concatenate with a CrossTable?

Re: Concatenate with a CrossTable?

Re: Concatenate with a CrossTable?