Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nikhilgarg
Contributor III

Re: Transposing data in QLiksense in chart

Hey,

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

last. Any workaround on this?

devarasu07
Honored Contributor II

Re: Transposing data in QLiksense in chart

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

Re: Transposing data in QLiksense in chart

Try this

add this in the script

LOAD * Inline [

dim

1

2

];

dimesnion

=pick(dim,Month,'YTD')

expression = PICK(your expressions,YTD EXPRESSION)

Highlighted
devarasu07
Honored Contributor II

Re: Transposing data in QLiksense in chart

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

Re: Transposing data in QLiksense in chart

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

Re: Transposing data in QLiksense in chart

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

Community Browser