Dimensions to Measures

[Anonymous]

Hi All,

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

Date	A	B	C	D	E	F	H	I	Total
1-Aug-17	402	18	1303	130	123	55	14	10	2055
2-Aug-17	472	24	1177	112	127	74	14	12	2012
3-Aug-17	517	21	1728	203	112	92	17	18	2708
4-Aug-17	515	23	1080	152	107	93	14	9	1993

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

[etrotter]

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.

[Anonymous]

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]

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]

In Pivot, You can have it as Column Dimension.

[mikaelsc]

crosstable load?

The Crosstable Load