topic Re: Exclude values if filter is selected in App Development

Exclude values if filter is selected

VictorBoscaro — Tue, 21 Dec 2021 21:56:36 GMT

I have a bar plot that shows the final stock of each year. Before 2017 these number are fixed (the client gave us the value that should be used for those years) and from 2017 we calculate this numbers.

What I need to do is hide the bar from 2014 to 2016 if I apply a filter in that sheet. How can I do it?

Thanks.

Re: Exclude values if filter is selected

QFabian — Tue, 20 Apr 2021 16:23:41 GMT

Hi @VictorBoscaro , one option is create a INLINE table with a new flag to use in your expression or as a filter to select between :

Flag:
Load * INLINE [
Monthname, Flag

nov-2016, Type1
dic-2016, Type1
ene, 2017, Type2
etc.
];