Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I need to display cumulative values for field 'BTC'.
The cumulative value is for the Finish period (Period must be displayed April-20, May-20 and so on.
using formula:
aggr(rangesum( above( sum(BTC),0,rowno())),[Finish])
I am struggling adding Month and year functions to 'Finish' formula.
Could anyone assist?
Here is a snapshot of the data file.
thanks a million.
Jose
Hi @JoseGarcia
Are you looking for cumulation based on Month-Year?
If so, try like below
LOAD Finish,
MonthName(Finish) as MonthYear,
[WBS Name],
BTC,
EVC,
ATC
FROM
[D:\Qlik\Com\Copy of temp1.2.xlsx]
(ooxml, embedded labels, table is Sheet2);
Dim: MonthYear, WBS Name
Exp: rangesum(above(sum(BTC),0,rowno(Total)))
Hi @JoseGarcia
Can you provide the sample file instead of image?
Hi Mayil,
here is the file.
Let me know if you need more details.
Jose
Hi @JoseGarcia
Are you looking for cumulation based on Month-Year?
If so, try like below
LOAD Finish,
MonthName(Finish) as MonthYear,
[WBS Name],
BTC,
EVC,
ATC
FROM
[D:\Qlik\Com\Copy of temp1.2.xlsx]
(ooxml, embedded labels, table is Sheet2);
Dim: MonthYear, WBS Name
Exp: rangesum(above(sum(BTC),0,rowno(Total)))
Mayil,
you are a genius! it works great!
Thanks a million for your support.
Jose
You are welcome