topic Re: set analysis filter in QlikView

set analysis filter

sunil1989 — Thu, 13 Jul 2017 09:03:57 GMT

Hi,

Can anyone help me with below expression

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

Thanks,

Sunilkumar

prma7799 — Thu, 13 Jul 2017 09:07:54 GMT

Try like this

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

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

sunil1989 — Thu, 13 Jul 2017 09:23:29 GMT

Tried but its not working

Kushal_Chawda — Thu, 13 Jul 2017 09:41:10 GMT

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.