Set Analysis with three flags

prathipsrinivas — Sat, 16 Nov 2024 04:31:47 GMT

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?

Re: Set Analysis with three flags

Gysbert_Wassenaar — Thu, 07 Feb 2019 11:06:02 GMT

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