Expression to avoid filter

[madhuqliklondon]

Hi,

I am trying to avoid selecting filter. I have working expression like below

sum({<[IO.Order Date]={">=$(=Date(today()-7,'DD/MM/YYYY'))<=$(=Date(today(),'DD/MM/YYYY'))"}>}IO.Quantity)

I am using straight table and I have multi box with product type drop down to standard and free, I need only free products, So I am selecting product type free in filter. I am trying to avoid filter. I am using below expression for it.. is this wrong?

sum({<[Item.Product Type]={'free'},[IO.Order Date]={">=$(=Date(today()-7,'DD/MM/YYYY'))<=$(=Date(today(),'DD/MM/YYYY'))"}>}IO.Quantity) 

Thanks in advance.

[Anil_Babu_Samineni]

In your expression, there is no wrong. Can you check one more whether free is your product type or FREE. I meant to say upper letter. Because Qlik is case sensitive you must use same name where your DB has?

What if you are not selecting any thing from multi box??

[prma7799]

Your expression looks like good

sum({<[Item.Product Type]={'free'},[IO.Order Date]={">=$(=Date(today()-7,'DD/MM/YYYY'))<=$(=Date(today(),'DD/MM/YYYY'))"}>}IO.Quantity)

Please try to check [Item.Product Type] weather it is in upper or lower format

[sunny_talwar]

The expression looks good to me.... is it not working?

[madhuqliklondon]

Yes, it is working now. Thank you.

[sunny_talwar]

What did you change?

[prma7799]

Please close this thread marking correct or helpful answer.

[madhuqliklondon]

Hi sunny , initially I have added this set date to only quantity column, then I have applied to every column.

Thank you all.