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?
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 ?
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
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
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?.
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.
Just tried to enable the Total on your Month Dimension (like attached screen )
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