topic Re: Ignore filter in QlikView

Ignore filter

MarkusG — Mon, 15 Mar 2021 13:16:56 GMT

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

Re: Ignore filter

Or — Mon, 15 Mar 2021 14:03:50 GMT

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?

Re: Ignore filter

benvatvandata — Tue, 16 Mar 2021 04:05:02 GMT

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')

Re: Ignore filter

MarkusG — Tue, 16 Mar 2021 05:58:41 GMT

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

Re: Ignore filter

MarkusG — Tue, 16 Mar 2021 06:05:05 GMT

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

Re: Ignore filter

Or — Tue, 16 Mar 2021 12:43:21 GMT

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.

Re: Ignore filter

MarkusG — Tue, 16 Mar 2021 13:02:37 GMT

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

Re: Ignore filter

Or — Tue, 16 Mar 2021 13:31:27 GMT

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.

Re: Ignore filter

MarkusG — Tue, 16 Mar 2021 13:40:51 GMT

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

I look further on