Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

qliklatitude
New Contributor

Dimensions to Measures

Hi All,

How can i convert dimensions headers to measure values for new dimension defined?

      

DateABCDEFHITotal
1-Aug-174021813031301235514102055
2-Aug-174722411771121277414122012
3-Aug-175172117282031129217182708
4-Aug-17515231080152107931491993

For given data is output of my pivot which I am using as a data table, how can i convert "A,B,C,D,E,F,G,H,I" into a Value for new defined dimension? It's difficult in Qlik Sense to read and visualize this data.

Thanks in advance

5 Replies
etrotter
Contributor II

Re: Dimensions to Measures

You have to delete the field that is a dimension, and then click "add data" and choose measure. Click the Field that contains "A,B,C,ect". Its going to ask you how you want it aggregated, meaning that in the even there are two values for one dimension, the measures have to be combined in order to make the table. Sum usually works best, and after it is a measure you can add your new dimension.

qliklatitude
New Contributor

Re: Dimensions to Measures

Hi Erica,

All these I have to do while data loading? or something else i'll have to do

My visualization pan is showing these value as Dimensions only..not getting option to consider this as measure.

Thanks,

Bhavik

etrotter
Contributor II

Re: Dimensions to Measures

No, this is all going to be front end, when you add a pivot table you should have an option of a measure versus dimension.

shraddha_g
Honored Contributor III

Re: Dimensions to Measures

In Pivot, You can have it as Column Dimension.

mikaelsc
Contributor III

Re: Dimensions to Measures

crosstable load?

The Crosstable Load