Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nikhilgarg
Contributor III

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
Honored Contributor II

Re: Transposing data in QLiksense in chart

try something as below for row expression:

Aggr( sum(your_measure_field), Month )

devarasu07
Honored Contributor II

Re: Transposing data in QLiksense in chart

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
Esteemed Contributor

Re: Transposing data in QLiksense in chart

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
Contributor III

Re: Transposing data in QLiksense in chart

Yes,

I am looking same kind of format

devarasu07
Honored Contributor II

Re: Transposing data in QLiksense in chart

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
Contributor III

Re: Transposing data in QLiksense in chart

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
Honored Contributor II

Re: Transposing data in QLiksense in chart

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
Contributor III

Re: Transposing data in QLiksense in chart

Hey Deva,

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

Thanks,

Nikhil Garg

devarasu07
Honored Contributor II

Re: Transposing data in QLiksense in chart

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