topic Re: How to ignore all selection exclude one in App Development

How to ignore all selection exclude one

phongnnguyen — Tue, 02 Oct 2018 11:03:54 GMT

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 — Tue, 02 Oct 2018 11:08:13 GMT

Try this

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

sunny_talwar — Tue, 02 Oct 2018 11:08:27 GMT

Or this

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

sunny_talwar — Tue, 02 Oct 2018 11:09:03 GMT

You can also look here

phongnnguyen — Tue, 02 Oct 2018 11:13:39 GMT

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

sunny_talwar — Tue, 02 Oct 2018 11:23:01 GMT

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

phongnnguyen — Tue, 02 Oct 2018 11:32:12 GMT

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

sunny_talwar — Tue, 02 Oct 2018 11:42:19 GMT

Okay