Crosstable issue

_emily — Mon, 20 Sep 2021 23:42:22 GMT

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!

Re: Crosstable issue

Andrei_Cusnir — Tue, 28 Sep 2021 13:49:26 GMT

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:

The first row is not expected to be loaded into Qlik Sense, as it is just information.
You want to load the fields Level 02, Level 03, Leve 04 ..., Measures, 202201, 202202 ...., 202212
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?

topic Re: Crosstable issue in Connectivity & Data Prep

Crosstable issue

Re: Crosstable issue