How can I make this data usable in Qlik to create a data visualization?
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!
Re: How can I make this data usable in Qlik to create a data visualization?
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!