Transposing data in QLiksense in chart

[nikhilgarg]

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

[nikhilgarg]

Hey,

I also did the same but totals are coming in the front and we want it at

last. Any workaround on this?

[devarasu07]

Hi,

Nope & it's not possible with the default sense pivot chart. may be u can try to find if any such kind of chart extension available in qlikbranch/GitHub portal

Thanks

Deva

[pradosh_thakur]

Try this

add this in the script

LOAD * Inline [

dim

1

2

];

dimesnion

=pick(dim,Month,'YTD')

expression = PICK(your expressions,YTD EXPRESSION)

[devarasu07]

Hi,

this method might won't give the desired o/p layout  (it will return similar month partial sum). current version of qliksense don't before and after total feature (sense pivot total by default added into front).

Thanks, Deva

[bhargav_bhat]

Hi Nikhil,

As Pradosh Thakur rightly suggested

add this in the script

LOAD * Inline [

dim

1

2

];

And use this in Dimension

=pick(dim,Month,'YTD')

in Expression

for

POVAL :- Pick(dim,POVAL expression,YTD Expression for POVAL)

SalesVAL :- Pick(dim,SalesVAL expression,YTD Expression for Sales VAl )

ForecastedVAL :- Pick(dim,ForecastedVAL expression,YTD Expression for ForecastedVal)

Also I have attached sample app for your reference

Regards,

Bhargav

[pradosh_thakur]

hi  Deva

I didn't notice he was asking for YTD. i thought he was asking for total and posted in a hurry . Now i have edited that . It shall work i think.

regards

Pradosh