Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

prathipsrinivas
Contributor

Set Analysis with three flags

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?

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Set Analysis with three flags

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


talk is cheap, supply exceeds demand
1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

Re: Set Analysis with three flags

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


talk is cheap, supply exceeds demand