Ignore filter

[MarkusG]

Hello everybody,

I have a question regarding how to ignore a filter.

Usualy it works in all other columns and charts but not here where i like to display the workingdays for each month even when i have selected a specific month.

I need to select a specific month due to show the performance in a different chart.

Here is my formula:

NetWorkDays(
min({<Department={'Printing'}, Monat=, Quartal=>}Datum),max({<Department={'Printing'}, Monat=, Quartal=>}Datum),
'01.01.2021','15.03.2021','02.04.2021','05.04.2021','24.05.2021','20.08.2021','01.11.2021','24.12.2021','25.12.2021')

here a screenshot with seleced February:

here without selection, how it should be displayed even with a month selected:

Can somebody help me?

Thank you and best regards

Markus

[Or]

It looks like you are explicitly ignoring the selection on the Monat (month?) field in your set analysis for the min and max formula, so that might be your problem here?

[benvatvandata]

Have you tried using set modifiers in your expression? i.e. put '1' in between '{' and '<'... so '{1<'...

Perhaps something like:

NetWorkDays(
min({1<Department={'Printing'}, Monat=, Quartal=>}Datum),max({1<Department={'Printing'}, Monat=, Quartal=>}Datum),
'01.01.2021','15.03.2021','02.04.2021','05.04.2021','24.05.2021','20.08.2021','01.11.2021','24.12.2021','25.12.2021')

[MarkusG]

Hi, thanks for your help, but then my entiere selection is ignored.

[MarkusG]

Hi,

thanks for your help.

1st: Monat = Month, right.

2nd: yes I like to ignore in that table the selection of an month and show the entiere year with the each month. the poblem is that i have to do a month selection due to objects in which i just show the actual or current month.

Thanks

[Or]

You can't both ignore the selections on a field and respect the selections on the same field... you have to either pick one of the two, or use a second field (or alternate state) for the selections you want to respect.

[MarkusG]

Oh nono,

not the same field.I need to be more precise.

Look:

here are the selection without a month but then in a different graph with a different deffinition the result is wrong because there i like to see just the data for February for e.g.

all other columns are doing it right, even when i ignore the selection for a month they display it right, only that column didn´t work like that

[Or · Accepted solution]

I've attempted to replicate what you say you are doing on my end (in QS, but it's the same thing) and I'm getting the result you seem to be expecting after selecting Feb 2020:

Are you perhaps selecting on a different field from the one contained within the table? Are other selections interfering with the formula? I'm not really sure what else might be the problem, but the base formula seems to be working fine under the circumstances you described.

[MarkusG]

Thank you for checking the formula, so anything else seems to be the problem.

I look further on