How to ignore all selection exclude one

[phongnnguyen]

Hello there,

I have a problem with my set analysis. I want to ignore all selection but exclude one field is Date. I tried to write like below but It dosent work.

count({1-$<Date={"*"}>}total distinct AccountID)

Total AccountID of my data is 92k. I want to ignore when i filter BranchID,EmID...except Date.

In my case, i dont want to use count({Branch=,...>}total distinct AccountID)

Thanks for your help

[sunny_talwar]

Try this

Count({1<Date = P(Date)>} TOTAL DISTINCT AccountID)

[sunny_talwar]

Or this

Count({1<Date = $::Date>} TOTAL DISTINCT AccountID)

[sunny_talwar]

You can also look here

Ignore all selections except few fields using Set Analysis

[phongnnguyen]

Thanks for your reply but they doesnt work both in my case too. I use Qlik Sense Desktop. So cant use P()

[sunny_talwar]

You have Qlik Sense Desktop which is why you can't use P()? Who told you that?

[phongnnguyen]

Today, I just know use P() in Qlik Sense. I will read the way to use it. Thanks a lot.

[sunny_talwar]

Okay