Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ezgisonmez
Contributor
Contributor

Converting measures to dimensions

Hello,

I have a project which have dataflow from many different data sources. I need to create a data model, calculate 27 different KPIs and 7 domains consisting of these 27KPIs. Each KPI may be loaded from different sources. I think to calculate these calculations in load editor. Actually there is no problem doing them. My problem is to be able to create a dimension that I have created these calculations as measure. I mean, I have 27 different calculations as measure, but also I need a field which includes the names of these 27 calculations.  In the attachment, you can find the screen shot that I want to get.

 

Thanks for any helps.

 

 
Labels (3)
1 Reply
berkarmagan
Partner - Creator
Partner - Creator

Hi,

I'm not sure that i totally understood the question but, i think you calculate all the measures and put them in one table right? 

You can use inline table, put 2 columns, one for key to your table which you have measures, and one for names. Than you can use this column for dimension.