Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hey,
I also did the same but totals are coming in the front and we want it at
last. Any workaround on this?
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
Try this
add this in the script
LOAD * Inline [
dim
1
2
];
dimesnion
=pick(dim,Month,'YTD')
expression = PICK(your expressions,YTD EXPRESSION)
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
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
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