topic Expression to avoid filter in QlikView

Expression to avoid filter

madhuqliklondon — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Expression to avoid filter

Anil_Babu_Samineni — Thu, 29 Jun 2017 10:56:54 GMT

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??

Re: Expression to avoid filter

prma7799 — Thu, 29 Jun 2017 11:00:06 GMT

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

Re: Expression to avoid filter

sunny_talwar — Thu, 29 Jun 2017 11:02:18 GMT

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

Re: Expression to avoid filter

madhuqliklondon — Thu, 29 Jun 2017 12:59:11 GMT

Yes, it is working now. Thank you.

Re: Expression to avoid filter

sunny_talwar — Thu, 29 Jun 2017 13:00:47 GMT

What did you change?

Re: Expression to avoid filter

prma7799 — Fri, 30 Jun 2017 04:02:53 GMT

Please close this thread marking correct or helpful answer.

Re: Expression to avoid filter

madhuqliklondon — Fri, 30 Jun 2017 08:14:42 GMT

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

Thank you all.