Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I have a problem. I am getting a null value because there are two records in my table with the same date, which is fine, but Qlikview displays this as a null, I have used expression FirstSortedValue([Cleared Amount],-Date) I would like to use FirstSortedValue(SUM[Cleared Amount]),-Date) but Qlikview doesnt like it, I could do a resident load but the report takes over an hour to reload.
Is is it possible to use sum in a firstsortedvalue statement?
Regards.
Paul.
Hi
Perhaps this:
FirstSortedValue(Aggr(Sum([Cleared Amount]), Date), -Date)
Hope that helps
Jonathan
You can't embed an aggregation function (sum()) into another (FirstSortedValue() ) without using advanced aggregation, so try something like
=FirstSortedValue( aggr(sum([Cleared Amount]),Date), -Date)
Or if you don't want to aggregate your Amounts because they are just duplicates, try DISTINCT qualifier:
=FirstSortedValue(DISTINCT [Cleared Amount], -Date)
Unfortunately that didn't work, Still got a null value,
Paul.
Are you trying to use the expression in script or in a chart expression?
Normal expression Swuehl, I am trying to sum to value amounts (off different rows) that have the same date.
Paul.
Did you ever find an answer to this issue? I am having the same issue and would appreciate if you could share your solution