Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Re: Expression help

May be this?

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

Highlighted

Re: Expression help

or this:

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