Set Analysis with three flags

[prathipsrinivas]

Hi Qlikers,

I have data like below in a qvd.

Name, Month1, Month2 , Month3

A, Y, -,-

A,-,Y,-

A,-,-,Y

and so on.

I want to show the data in Straight Table when Month = Y, Month2 = Y, MOnth3=Y

When I write this in set analysis it is giving null.

Can you please help me out here on how to achieve this?

[Gysbert_Wassenaar · Accepted solution]

Perhaps something like count({<Name=P({<Month1={'Y'}>}Name)*P({<Month2={'Y'}>}Name)*P({<Month3={'Y'}>}Name)>} Name)