Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mbanerjee95
New Contributor

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

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

Tags (1)
4 Replies
arvind_patil
Valued Contributor II

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

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
Esteemed Contributor II

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

can you post a sample excel?

mbanerjee95
New Contributor

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!

snap.PNG

vinieme12
Esteemed Contributor II

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