Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

vinayvishwanath
New Contributor II

Converting measure into dimension in Qlik sense

Hi All,

I have data given in below format, wherein it is monthly forecast from P1 (Jan) to P12 (Dec) and need to represent the same in Qlik sense Period wise P1, P2 ...... as chart shown below (excel charts as a reference)

Monthly forecast
P1P2P3P4P5P6P7P8P9P10P11P12
488455.8440029441172.8441626.4450544.8456014.9380620.5438305461611.9476927.7461611.9438305
746558.21465887656513.9912060.31062828902009.1771343.8932162.7922111.51153289992469.7992469.7

Capture.PNG

1 Solution

Accepted Solutions

Re: Converting measure into dimension in Qlik sense

Suggest you to transform your data in the script using The Crosstable Load

1 Reply

Re: Converting measure into dimension in Qlik sense

Suggest you to transform your data in the script using The Crosstable Load

Community Browser