Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Advanced transformation of XLS

Hi,

I have problem transforming xls in attach (ETL Example.xlsx) into suitable form for import in QlikView. I found two parts most challenging:

  • 2012 cell: I dont know how to deal with it
  • fact that first 4 columns are fixed: if it was only one I could solve that problem using transpose > fill value > and then crosstable. But this way I get "multiple label rows"

Thank you in advance.

Milan

1 Reply
Not applicable
Author

Lil strange situation, but after couple of hours I have the answer

You do same thing as I described in second cue, and afterwards you left join other 3 fixed columns...

Additional explanation is available ofc if anyone needs.

Regards,

Milan