Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Perhaps something like count({<Name=P({<Month1={'Y'}>}Name)*P({<Month2={'Y'}>}Name)*P({<Month3={'Y'}>}Name)>} Name)
Perhaps something like count({<Name=P({<Month1={'Y'}>}Name)*P({<Month2={'Y'}>}Name)*P({<Month3={'Y'}>}Name)>} Name)