topic AW:if only statement in QlikView

if only statement

Mon, 21 Mar 2011 13:18:14 GMT

Hi,

I am back again with a simple question, and very much hopeful to get the help from experts:)

I have a simple table like below

FL	MS
AA	X
AA	Y
AA	Z
BB	Y
BB	Z
CC	Z
CC	Y
DD	W
DD	Y
DD	Z

Now if I select both fields on QV and select Y and Z from the MS selection list, the FL list should only show those containing ONLY Y and Z

right now, when i select y and Z, the FL list shows all the values which even have ONLY 'Y' OR 'Z'

a sudocode might be like

Select FL if only (MS='Z' AND MS='Y')

The resutl as per above table should be BB and CC only

Thanks in advance.

KRs/Asad

AW:if only statement

brenner_martina — Mon, 21 Mar 2011 13:37:55 GMT

Hi,

look at the example, I used set analysis, maybe that helps you

AW:if only statement

Mon, 21 Mar 2011 13:46:30 GMT

Hi Martina,

Thanks for your help but unfortunately, I still have the free version of QV, using for testing before we buy its licence, so I am unable to open your attached file, can you please share the code?

Thanks & BRs,

Asad

if only statement

Mon, 21 Mar 2011 14:23:43 GMT

The expression from the file that Martina posted above that only shows B and C is

Expression:

=If(Count({<MS/={"Y","Z"}>} MS)=0, Count(MS),0)

But it shows 2 for both, I suppose if you only wanted it to say 1 you could just use count(distinct .

if only statement

Tue, 22 Mar 2011 08:13:17 GMT

Hi,

Thanks but not worked yet

KRs/

if only statement

Tue, 22 Mar 2011 10:46:33 GMT

Hi again,

Thanks for the help again, I applied the suggested set analyses but got a problem after expanding my table. Now the table looks like below:

FL	MS	position
AA	X	1
AA	Y	2
AA	Z	3
BB	Y	1
BB	Z	2
CC	Z	1
CC	Y	2
DD	Y	1
DD	Y	2

and the suggested code returns DD as well.

Please help.

Thanks & BRs,

Asad