topic Set Analysis syntax in QlikView

Set Analysis syntax

Anonymous — Thu, 21 Oct 2010 17:04:44 GMT

What would be the correct syntax for the below?

count({$<(fielda={'Y'} + fieldb={'N'},fieldc={'Z'}>} Items)

The above gives me syntax error.

Thanks,

Dinesh.

Set Analysis syntax

Thu, 21 Oct 2010 17:09:08 GMT

Almost correct.

count({$<fielda={'Y'},fieldb={'N'},fieldc={'Z'}>} Items)

Set Analysis syntax

Anonymous — Thu, 21 Oct 2010 17:49:25 GMT

This is basically an and condition between the 3 fields. What I want is ((fielda=Y OR fieldb=N) AND (fieldc=Z)). I put a + for the union command. Is the above possible?

Thx

Set Analysis syntax

Thu, 21 Oct 2010 18:27:10 GMT

i don´t know if is possible....but i find a set analisys material.....and found it!

+	Union	Returns the set of all records that belong to the unioned sets
-	Exclusion	Returns records that belong to the first but not the other of the two set identifiers.
*	Intersection	Returns records that belong to both of the set identifiers.
/	Symmetric Difference	Returns a set that belongs to either, but not both of the set identifiers.

I think the last one is usefull for you.....but i never have been tested!!!!!

Set Analysis syntax

Miguel_Angel_Baeyens — Thu, 21 Oct 2010 19:27:52 GMT

Hello,

Try my code in this post.

Hope that helps!

Set Analysis syntax

Anonymous — Thu, 21 Oct 2010 21:18:17 GMT

This is very helpful. The only pain I now see is that I have to repeat the code for fieldc in both places. There are many such fieldc's which I need to add & would be nice if I do not have to repeat the code.

Thanks,

Dinesh.

Set Analysis syntax

Miguel_Angel_Baeyens — Thu, 21 Oct 2010 21:38:18 GMT

Hi Dinesh,

I don't know if you mean you have lots of expressions to change. If that's the case, give a try to the Settings menu, Expression Overview. From there you can replace some code in your expressions if needed.

Hope that helps.

Set Analysis syntax

Thu, 21 Oct 2010 21:40:28 GMT

I don't think you need to repeat the fieldCs.

count({$(<fielda={'Y'}>+<fieldb={'N'}>)*
<fieldc={'Z'}>} Items)

You could use any number of FieldCs:

count({$(<fielda={'Y'}>+<fieldb={'N'}>)*
<fieldc={'Z'}>*<fieldd={'R'}>*<fieldzzzztop={'O'}>} Items)

Which should be the same as:

count({$(<fielda={'Y'}>+<fieldb={'N'}>)*
<fieldc={'Z'},fieldd={'R'},fieldzzzztop={'O'}>} Items)

Set Analysis syntax

Fri, 22 Oct 2010 03:06:24 GMT

count({$<(fielda={'Y'} ,fieldb={'N'},fieldc={'Z'}>} Items)