Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an qliksense table as below.
I want the new field Total Month to be calculated as below. Is it possible using any expression? Thanks
MonthDate Day Amount Total Month
April 01 500 2000
April 02 1500 2000
May 01 2000 4500
May 02 2500 4500
Just use Sum(Total<MonthDate> Amount) for your Total Month expression
Just use Sum(Total<MonthDate> Amount) for your Total Month expression
try with the TOTAL
Sum(TOTAL <MonthDate> Amount)
You can read more on TOTAL
https://community.qlik.com/t5/Qlik-Design-Blog/The-Aggregation-Scope/ba-p/1467321
https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990
Thanks.
It presents me with an wrong value.
Sorry, I validated the data wrongly. Actually it worked.
Thanks much for your help.
Hi Max, Thanks for the resources, I will go over it.