Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sunil1989
Contributor
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
Master III
Master III

Try like this

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

or

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

sunil1989
Contributor
Contributor
Author

Tried but its not working

Kushal_Chawda

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.