Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
alextomlins
Contributor III
Contributor III

Limiting Set Analysis by >10

I'm having a bit of a moment. I remember doing this before somewhere in one of my applications. I would like to only include products where the count of LicenceeLicenceID is above 10 say. The percentages are too sensitive so i'dd like to excllude those products. Completely forgotten.



(Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}>}LicenceeLicenceID))


/


(Count({<tType={'AllLicences'}>}LicenceeLicenceID))


Thanks,


Alex

1 Solution

Accepted Solutions
agigliotti
Partner
Partner

maybe this:

(Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}, productID = {"=Count(LicenceeLicenceID)>10"} >}LicenceeLicenceID))

/

(Count({<tType={'AllLicences'}, productID = {"=Count(LicenceeLicenceID)>10"}>}LicenceeLicenceID))


I hope it helps.

View solution in original post

4 Replies
alextomlins
Contributor III
Contributor III
Author

AllLicences is just a subsection because the tables are duplicated for a reason and so i'm only looking here

YoussefBelloum
Champion
Champion

Hi,

you can try this:

(Count({<LicenceeLicenceID={"=Count(LicenceeLicenceID)>10"},tType={'AllLicences'}, Over24Hour={'Under24Hours'}>}LicenceeLicenceID))


/


(Count({<LicenceeLicenceID={"=Count(LicenceeLicenceID)>10"},tType={'AllLicences'}>}LicenceeLicenceID))

agigliotti
Partner
Partner

maybe this:

(Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}, productID = {"=Count(LicenceeLicenceID)>10"} >}LicenceeLicenceID))

/

(Count({<tType={'AllLicences'}, productID = {"=Count(LicenceeLicenceID)>10"}>}LicenceeLicenceID))


I hope it helps.

View solution in original post

sunny_talwar

Not entirely sure if you want to exclude less than 10 for all tTypes or just where it is AllLicences? May be try one of these

(Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}, LicenceeLicenceID = {"=Count({<tType={'AllLicences'}>}LicenceeLicenceID) > 10"}>}LicenceeLicenceID))


/


(Count({<tType={'AllLicences'}, LicenceeLicenceID = {"=Count({<tType={'AllLicences'}>}LicenceeLicenceID) > 10"}>}LicenceeLicenceID))

or this

(Count({<tType={'AllLicences'}, Over24Hour={'Under24Hours'}, LicenceeLicenceID = {"=Count(LicenceeLicenceID) > 10"}>}LicenceeLicenceID))


/


(Count({<tType={'AllLicences'}, LicenceeLicenceID = {"=Count(LicenceeLicenceID) > 10"}>}LicenceeLicenceID))