topic Re: ¿How to exclude only one selection? in QlikView

¿How to exclude only one selection?

Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I have some problem when I want to count a values and filter by some selections.

I have the following count:

Count({$<[Status]={'closed'},[Type]={'PC'}>}[Task]))

And I have the following selections:

REGION

CITY

COUNTRY

DATE

I need that the count works with the selections REGION, CITY and COUNTRY, but if I select some value of DATE does not import in the count.

I don't know if I can put in the formule some keyword to block this selection (DATE), ONLY for this count.

Best regards.

Re: ¿How to exclude only one selection?

swuehl — Tue, 12 Apr 2016 16:21:39 GMT

Try to ignore the DATE selection like

Count({$<[Status]={'closed'},[Type]={'PC'}, DATE= >}[Task]))

Re: ¿How to exclude only one selection?

engishfaque — Tue, 12 Apr 2016 16:28:57 GMT

Dear Juan,

When you are writing your set analysis just write your "Field Name with = sign" such as Date =.

So, your requirement is that when you select Date Field no count perform for [Task]. Your expression is right just append with one more modifier ", Date = ". Such as @Stefan shared you set analysis.

Kind regards,

Ishfaque Ahmed

Re: ¿How to exclude only one selection?

Chanty4u — Wed, 13 Apr 2016 09:33:27 GMT

chk dis

Excluding values in Set Analysis

Re: ¿How to exclude only one selection?

ben_mckenna — Fri, 23 Feb 2018 09:51:52 GMT

Did exactly the job for me, thanks! Now my measure responds to any selection the user makes, except for the dimension I've chosen.