- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Excluding values based on date in multiple sheet objects but not all
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you want to exclude dynamically or static. And what values you have in $(vSetExcludeItems).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The values are static.