Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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??
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
The expression looks good to me.... is it not working?
Yes, it is working now. Thank you.
What did you change?
Please close this thread marking correct or helpful answer.
Hi sunny , initially I have added this set date to only quantity column, then I have applied to every column.
Thank you all.