Grouping flaw projects

[rammuthiah]

I have projects lets say A,B and C and corresponding status as Green, Yellow nd Red.

For eg.

Month, Project, Status, Remarks

May 2021, A, Green, Not a Flaw

May 2021, A, Red, Flaw

May 2021, B, Red, Flaw

May 2021, C, Red, Flaw

May 2021, C, Yellow, Flaw

May 2021, D, Group, Not a Flaw

O/P Needed: If status of Project is Red or Yellow, then

May 2021 : A,B,C.

I tried,but i am not able to get all projects based on year, If i Click on particular flaw project, then only it is showing the Project 

[Dalton_Ruer]

From your explanation it sounds like Qlik is doing exactly what it is designed to do. If you create a filter box and you filter to a particular Project (A, B, C or D) then you have essentially filtered the data to just include that specific project. If that project is only in Year 2020, then you won't see values for the Year 2021. 

If the problem is that you are trying to select 2021 as the year, the problem you have in your data model (as shown) is that you don't have a Year field, you have only a Text field that shows Month Name and Year combined.

I modified your load script slightly to this:

Data:
Load * Inline [
Month, Year, Project, Status, Remarks
May, 2021, A, Green, Not a Flaw
May, 2021, A, Red, Flaw
May, 2021, B, Orange, Flaw
May, 2021, C, Red, Flaw
May, 2020, C, Yellow, Flaw
May, 2020, D, Orange, Not a Flaw
];

Notice in this image that when I filter the Status to Green, anything that didn't involve a Green status is shown in dark grey, to imply it's excluded. It's the data I would have left behind if I issued a SQL Where Clause.

 Since I have broken out Year as it's own field I am able to select either year, and then notice that other values respond. 

[rammuthiah]

Thanks for the reply. I need the o/p like May 2021 : A,B,C in a single cell,

For E.G:

May 2021 : A,B,C in 1st row

Jun 2021 : B,C in 2nd row likewise....

[BjoernLangeLeapLytics]

Hi, 

we are offering extensions for QlikSense, which makes it possible to show projects in a single and portfolio-like view. The Traffic Light Extension and Risk Heatmap could help you in your Use Case. You can download it in Garden Banch: 

https://developer.qlik.com/garden/5fd6531adae7960011eb30ec

https://developer.qlik.com/garden/5fa315a3495c3700115f38b5