Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Advanced transformation of XLS


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.


1 Reply
Not applicable

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.