Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Oli7835
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
andoryuu
Creator III
Creator III

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?

Oli7835
Contributor
Contributor
Author

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... 😞