How to write this Set analysis

Tue, 25 Oct 2011 08:21:00 GMT

Hi Experts,

I have two tables:

tb1:

MemberId, Flag2

1,1

2, null value

tb2:

MemberId,Flag, Usage

1,1,100

2,2,200

It is clear that the MemberId is used as connection Key.

Now I want to use Set analysis to get the usage whose Flag2 is Null.

I use this one =sum({<Flag2={'=IsNull(Flag2)'}>} Usage), but it does not work, how to write it? And I want it show in Text Object.

Thanks.

sbaldwin — Tue, 25 Oct 2011 08:53:31 GMT

Hi, You could try something like this:

=count( {<MemberId = e({<Flag2 = {'>0'} >} MemberId) >} MemberId)

in a table against usage or in a text box if there is only one:

=only( {<MemberId = e({<Flag2 = {'>0'} >} MemberId) >} Usage)

Thanks

Steve

topic How to write this Set analysis in QlikView