Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to get the total of expression in a pivot table in QlikView based on the Month which is the dimension. Following is the example table:
Month | Amount |
Apr-16 | 456 |
May-16 | 5325 |
Jun-16 | 535 |
Total | 535 |
Please help me how this can be achieved
Thanks,
Suhas Archak
Sum({<Month = {=max(Month)}>} Amount)
Is Month looking Month(Date) & '-' & Left(Year(Date),2) as Month
May be like this:
Max(Aggr(Sum(Amount), Month))
No Sure I understand your question, but I believe you can group the sum by month
Sum(Total <Month> Amount)
Hi,
Thanks for your replies. I tried all options but could not get the desired result. The expectation is to get the latest month's sum amount in the totals. In my example, I need to display 535 in totals as the sum of amount being for June which is the latest month.
Thanks
How about this?
=FirstSortedValue(Aggr(Sum(Amount), MonthYear), -MonthYear)
maybe this?