Excluding values based on date in multiple sheet objects but not all

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

Hi,

I am new to qlik and I am wondering if there is a smarter way to exclude certain values based on date. I have a document with a lot of sheet objects and reports that I should remove certain products from, I should however not remove them from all sheet objects.

Currently I am using an if statement with set statement , i.e. if( year >=2019, sum({<$(vSetExcludeItems)>} SalesQty), sum(SalesQty))

This a simplified statement, but just to show what I mean. There is more than 20 sheet objects that I need to exclude it from, and in each object in all expressions. All the expressions differ so I can not just do a copy paste.

Is there any better way to do this? I am also wondering how much it will affect performance to have if statements in the majority of the expressions?

Re: Excluding values based on date in multiple sheet objects but not all

ashok_rajm — Fri, 05 Apr 2019 10:43:14 GMT

Hi,
Do you want to exclude dynamically or static. And what values you have in $(vSetExcludeItems).

Re: Excluding values based on date in multiple sheet objects but not all

Qlik_vic — Fri, 05 Apr 2019 19:38:12 GMT

The values are static.

topic Re: Excluding values based on date in multiple sheet objects but not all in QlikView

Excluding values based on date in multiple sheet objects but not all

Re: Excluding values based on date in multiple sheet objects but not all

Re: Excluding values based on date in multiple sheet objects but not all