Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
There is a Chart in which i have a runing total ....
what i want is a new calculated dimension or a a field which should be named a s Carryfirward when i select say for example March-2016 then there shoulb be a values for carryforward from previous values of Feb-2016..
In the chart i have openstatus closed status and Rolling total ... when i male current selcetions the prvious month Rolling total should add to current rollling total and display ...
Please someone help me on this ..
Iam attaching the QVW file for refrence
Thakns in advance
what is the output you need when Mar 2016 is selected?
I think do you want maintain the value of RunningTotal (is the acumulated column)
Why you don't make the expresion inside the script?
P.D. I'm trying to do it with Set Analysis, but I think is not possible. I tried this (Set Analysis and RangeSum | Qlik Community)
Regards
HI Kushal .
When i slect any of the current year then it should there showuld be a column which should values for previous years months the
What value would that new column for previous year months show when you select Mar 2016?
HI Sunny ,
If you look at the straight table there something called Rollling Total..
Basically will be selecting year for exampl if i select 2016-Dec then it will show the Rollintotal from Dec back to 11 months that is Jan till Dec....
And i want to display the Previous month totals also ..........That is carry forwarding
thanks
John can you just give the exact numbers you are looking for?
Hi sunny
For example if iam selecting Mar-2016 , then the filed should show the value of Sum(open)- sum(close ) for the month of Feb-2016 and this shoul be carry out and added to Rolling total that is Mar-2016
And this is how it should work for the selction ....
I want to display within the chart and add dimension column which shoul show a previous month rolling ttal which should act a s a carry forward
Hi Sunny ,
Ok
please select Feb-2014
and you can see in the chart that the rolling total is -13 ,
and there should be a clumn which should display -18 for Jan-2014 ( one month before the current month selection )
and this -18 should add up with the Rollling total of current sellected monthyear .(-18 + -13 )
THanks
Where are you seeing -13?