How can I make this data usable in Qlik to create a data visualization?

[Anonymous]

Hello all,

I am currently working on a Qlik Sense visualization regarding health care spending and I am planning to use this data sheet. However, given the format that it is in, I'm not sure how to make working dimensions and measures within Qlik Sense to display this data. Each column is not an aggregation of everything combined and I'd like to show these trends over times in their respective years. How can I go about solving this? Would I have to go into the data load editor or edit the sheet in Excel? I'm attaching a screenshot for your convenience, thanks again in advance and I look forward to hearing from you all!

Sincerely,

Debashish

[arvind_patil]

Hi Debashish,

I think you need to load your data two time,

Firstly understand your data is in cross table.

your Dimesions are:  AgeGroup , gender, year,

measure are: Sum(levels),Sum(Avegare Annual Growth),

Load Male, Female Data Separately then you will also get total Data.

Thanks,

Arvind Patil

[vinieme12]

can you post a sample excel?

[Anonymous]

My Excel data looks like this, the arrows are showing how I want "Levels" and "Average Annual Growth" to be the headers for multiple columns and not just one. How can this be done? And how can I proceed with the cross table in order to use this data? Thanks again!

[vinieme12]

Refer this post

multi_header_pivot_import.qvw