Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Expression help

Hi,

I have the following expression and I would like to add where trade_dt is less than a variable vyesterday.

Sum(aggr(sum(DISTINCT pos_lots),pcr_num))

Let vYesterday = Date(Today()-1,'DD/MM/YYYY');

Regards,

Daniel

2 Replies
Highlighted
MVP
MVP

May be this?

Sum(aggr(sum(DISTINCT {<trade_dt={'<$(vYesterday )'}>}pos_lots),pcr_num))

Highlighted

or this:

Sum(Aggr(Sum(DISTINCT {<trade_dt = {"$(='<' & vYesterday)"}>} pos_lots), pcr_num))