Crosstable issue

[_emily]

Hi 😊

I've been struggling to get the data in the attached screenshot loaded into sense and figured I'd reach out. I've used crosstables with data from the same (although slightly differently formatted) source before but I can't work out what I'm doing wrong this time. I seem to never get the years as a dimension or wind up with everything being slightly skewed. Any advice or suggestions? 

Thanks!

Em

[Andrei_Cusnir]

Hello,

If my understanding is correct, you are trying to load the data from the EXCEL sheet to the Qlik Sense. Please correct me if I am wrong, this is my understanding based on the information that you have provided:

1. The first row is not expected to be loaded into Qlik Sense, as it is just information.
2. You want to load the fields Level 02, Level 03, Leve 04 ..., Measures, 202201, 202202 ...., 202212
3. You expect to use the date fields as dimensions

Is this the expected outcome? 

In case my understanding is incorrect, can you please elaborated further in detail as to how do you want to import your dataset?