topic How to force select today() in this expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-force-select-today-in-this-expression/m-p/866145#M994767 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Count({$&lt;ShipmentStatus={'Completed'}&gt;}DISTINCT(CarrierID)) </P><P></P><P>I just wanted to display always based on today's dates. </P></BODY></HTML> Tue, 14 Jul 2015 08:01:51 GMT MuraliPrasath 2015-07-14T08:01:51Z How to force select today() in this expression? https://community.qlik.com/t5/QlikView/How-to-force-select-today-in-this-expression/m-p/866145#M994767 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Count({$&lt;ShipmentStatus={'Completed'}&gt;}DISTINCT(CarrierID)) </P><P></P><P>I just wanted to display always based on today's dates. </P></BODY></HTML> Tue, 14 Jul 2015 08:01:51 GMT https://community.qlik.com/t5/QlikView/How-to-force-select-today-in-this-expression/m-p/866145#M994767 MuraliPrasath 2015-07-14T08:01:51Z Re: How to force select today() in this expression? https://community.qlik.com/t5/QlikView/How-to-force-select-today-in-this-expression/m-p/866146#M994768 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P>Count({$&lt;ShipmentStatus={'Completed'}, myDate={'$(=Today())'}&gt;}DISTINCT(CarrierID))</P></BODY></HTML> Tue, 14 Jul 2015 08:07:42 GMT https://community.qlik.com/t5/QlikView/How-to-force-select-today-in-this-expression/m-p/866146#M994768 alexandros17 2015-07-14T08:07:42Z