Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
prathipsrinivas
New Contributor III

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

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

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
Community Browser