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: 
phongnnguyen
Contributor II
Contributor II

How to ignore all selection exclude one

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

7 Replies
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

phongnnguyen
Contributor II
Contributor II
Author

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
Contributor II
Contributor II
Author

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

sunny_talwar

Okay