Discussion board where members can get started with Qlik Sense.
I also did the same but totals are coming in the front and we want it at
last. Any workaround on this?
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
add this in the script
LOAD * Inline [
expression = PICK(your expressions,YTD EXPRESSION)
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).
As Pradosh Thakur rightly suggested
And use this in Dimension
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
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.