Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Formule request to filter datas

Hi,

I've got a list of sites with different type and qty of products.

i.e:

  • Site 1 : product A
  • Site 1 : product B
  • Site 2 : product A
  • Site 2 : product C
  • Site 3 : product A
  • Site 4 : product A
  • Site 4 : product C

I want to upgrade all products excepted the Product B

My help request : I need to count the number of sites which can have 100% of their products upgraded, meaning in my example:

Site 2 + Site 3 + Site 4 = 3 sites (Site 1 is not counted as only one of 2 products can be upgraded)

Do you have any ideas how to do it?

Thanks in advance

Labels (1)
2 Replies
Creator III
Creator III

Re: Formule request to filter datas

How do you determine what the population of upgradeable products is?  Distinct list of products?  Do you have this list in your data model somewhere?

Highlighted
Contributor
Contributor

Re: Formule request to filter datas

in Qlik Sense, I've got the list of the Product from the database but not distinct, as shown in my example.

If needed, I can create one

What do you thing about?

My think is to get a formule to count the number of disctinct sites and also counting the number of product with the same name site - -without filter

And after filtering the data (to exclude the product B) and divide the number of products per same name site by the one after filtering it.

If the result is different to 1, I don't count it....

But how to do that... 😞