project count

[henry62]

I am working on a project in Qlik Sense, and I need to calculate the project count for projects that are aligned with multiple investment categories. Specifically, I would like to distribute the count of each project evenly among its associated categories. For example, if 'Project A' is aligned with three investment categories, each category should receive one-third of the total count. How can I achieve this in Qlik Sense?

[pallavi_96]

Hi Henry,

I tired to get the answer to your inquiry to the extent that I understood it.
Please determine whether it is helpful to you or not.

Raw_Data:
Load * Inline
[
Category,Product
Cat1,A
Cat2,A
Cat3,A
Cat1,B
Cat2,B
];

NoConcatenate

GroupbyCategory_Product:
Load distinct Category,
Product,
Count(Category) as #_Of_Cat
resident Raw_Data
group by Category,Product;

GroupbyProduct:
Load distinct
Product,
Count(Product) as #_Of_Prod
resident Raw_Data
group by Product;

drop table Raw_Data;

Exit script;