project count

henry62 — Fri, 15 Nov 2024 21:24:38 GMT

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?

Re: project count

pallavi_96 — Thu, 14 Sep 2023 05:27:12 GMT

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;

topic Re: project count in App Development

project count

Re: project count