topic Re: Or And in set analysis in QlikView

Or And in set analysis

Fri, 05 Jul 2013 06:01:15 GMT

Hi Exterts,

Can you tell me , by default what we have in set anlysis. Is it OR or AND operatiion.

For example.

sum({<Region={'Asia','Europe'},Country={'India','US','UK'}>}Sales)

Here in above example , what will be the operation by default.

If we want to use OR or AND , how do we implement.

Please answer my 3 questions.

Advance thanks..

Re: Or And in set analysis

Fri, 05 Jul 2013 06:04:36 GMT

default take OR operator represents by comma

Re: Or And in set analysis

Fri, 05 Jul 2013 06:07:25 GMT

Thnaks for your quik response.

But can you give me few more information like...

if we want to perfom externally, how do we implement AND , OR operations. Can you modify the expression from my earlier post.

Re: Or And in set analysis

Fri, 05 Jul 2013 06:09:57 GMT

in set analysis

+ Union (Returns the set of all records that belong tothe 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 theset identifiers.)

/ Symmetric Difference (Returns a set that belongs to either, but not both of the set identifiers.)

Re: Or And in set analysis

Fri, 05 Jul 2013 06:17:27 GMT

Updated code

Bydefault take OR---

sum({<Region={'Asia','Europe'},Country={'India','US','UK'}>}Sales)

for OR--

sum({<Region={'Asia'}> + <Region={'Europe'}> + <Country={'India','US','UK'}>}Sales)

for And

sum({<Region={'Asia'}> * <Region={'Europe'}> + <Country={'India','US','UK'}>}Sales)

Re: Or And in set analysis

saumyashah90 — Fri, 05 Jul 2013 06:23:08 GMT

It takes Or Operation in set analysis by default if commas are used like in your example

Re: Or And in set analysis

Fri, 05 Jul 2013 06:24:47 GMT

example--

The"+"-sign is used for OR in set analysis

An "OR" in set analysis is a union of two sets. You do a union with the "+" operator like so:

sum({<Year={2012}>+<Region={US,SE,DE,UK,FR}> Sales)

Re: Or And in set analysis

er_mohit — Fri, 05 Jul 2013 06:44:08 GMT

hiiii in set analysis condition it work as OR because the , separated which you ll put conditions are always act in or

but if you want AND then the expression is using by * puts a condition in it

sum({<Region={'Asia','Europe'},Country={'India','US','UK'}>}Sales)

moreover see the attached set analysis file will help you alot