Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sunil1989
New Contributor

set analysis filter

Hi,

Can anyone help me with below expression

=Sum({<BookedDeliveryDateKey = {=Num#(Date(Today(),'YYYYMMDD'))}>}Item_Volume)

Thanks,

Sunilkumar

3 Replies
prma7799
Honored Contributor III

Re: set analysis filter

Try like this

{"(=Num#(Date(Today(),'YYYYMMDD')))"}

or

{"(=Date(Today(),'YYYYMMDD'))"}

sunil1989
New Contributor

Re: set analysis filter

Tried but its not working

Re: set analysis filter

this should be like below

=Sum({<BookedDeliveryDateKey = {"$(=Date(Today(),'YYYYMMDD'))"}>}Item_Volume)


if it's not working then check the Format of BookedDeliveryDateKey. You need to provide the same format in set analysis.