Discussion Board for collaboration regarding Qlik DataMarket.
I have a table
and i need to get the
1.) max(date) sum of sales value. max(date) should be a variable
2.) day before the max(date) sum of sales value
I am not sure I follow your requirement? What are you trying to do?
Can you maybe share the expected output and also do you want this on the front end or backend?
1. FirstSortedValue(aggr(sum(sddrp),date), -date)
2. FirstSortedValue(aggr(sum(sddrp),date), -date,2)