Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Transposing data in QLiksense in chart

Hello All,

I ahve a straight table as attached in the image. I want to transpose this. I want my months to be shown as Columns and Measures as rows. I tries pivot table as well but it wont take measures as dimensions. Can a nyone help em in this?

thanks,

Nikhil Garg

15 Replies
agigliotti
Partner - Champion
Partner - Champion

try something as below for row expression:

Aggr( sum(your_measure_field), Month )

devarasu07
Master II
Master II

Hi,

In feature, try to share the mock data in excel format,

using pivot table u can able to do the transformation (row into column.)

r u looking like this o/p ?

Capture.JPG

Thanks

Deva

OmarBenSalem

You have to use a pivot table to achieve this; and being able to transpose your measures and dimensions.

Edit : didn't see Devarsu's reply ! Do as he said, it's the right way to achieve this

nikhilgarg
Specialist II
Specialist II
Author

Yes,

I am looking same kind of format

devarasu07
Master II
Master II

Hi,

you can refer to steps from attached app (remember to drag measure from column to row and month to column )

and let us know if any issue. once all ok then help to close this thread. tks

nikhilgarg
Specialist II
Specialist II
Author

Hey,

Thanks . Now i want to show YTD value as well as last column i.e. after month Dec, i want a column YTD showing YTD for all 3 measures. Can you help em in this?.

devarasu07
Master II
Master II

Hi,

When we do the transformation we can add only total of dimension value ( u r case Month ) at the end column. if u wish to shown YTD measure as column then it's possible in previous transformation state. i would suggest you to provide mock data and expected output then we can try if there workaround method.

Thanks,

Deva

nikhilgarg
Specialist II
Specialist II
Author

Hey Deva,

Pls. find the attached excel file showing the output that i want. Can you help me in this?

Thanks,

Nikhil Garg

devarasu07
Master II
Master II

Hi

Just tried to enable the Total on your Month Dimension (like attached screen )

Capture.JPG

P.S: Default qliksense pivot chart have show total as before and don't have after option. the total label u can changed to YTD total

Thanks,Deva