Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

¿How to exclude only one selection?

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.

4 Replies
swuehl
MVP
MVP

Try to ignore the DATE selection like

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

engishfaque
Specialist III
Specialist III

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

Chanty4u
MVP
MVP

ben_mckenna
Contributor II
Contributor II

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