Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

data equal expression not working?

I have a table

  

datesddrp
12-04-16100
12-04-1650
13-04-1625
13-04-1630
14-04-1645
14-04-1635

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

2 Replies

Re: data equal expression not working?

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?

Re: data equal expression not working?

1. FirstSortedValue(aggr(sum(sddrp),date), -date)

2. FirstSortedValue(aggr(sum(sddrp),date), -date,2)


talk is cheap, supply exceeds demand
Community Browser