How to use the operator of set analysis, using bookmarks

rnepla83 — Wed, 03 Aug 2011 10:44:57 GMT

Hi to all. In the attachment there is a file qvw with my problem.

1. Select FIAT GRANDE PUNTO and presso 'Book 1' to store this selection in the first bookmark

2. Select FIAT PANDA MY 03 and presso 'Book 2' to store this selection in the second bookmark

'now there are two bookmarks called Set1 and Set2 and i would like to build a Set Analysis using this bookmarks'

- If you wanna visualize the CONSUMER_ID have bought FIAT GRANDE PUNTO press the button 'Set 1'.

Will be {16,17,18,19,20,21,22,23,24,25,26,32,33,34,35}

- If you wanna visualize the CONSUMER_ID have bought FIAT PANDA MY 03 press the button 'Set 2'.

Will be {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20}

Follow the questions:

Q1: I would like to visualize the distinct count of CONSUMER_ID have bought both cars like the INTERSECTION of Set1 * Set2 = {16, 17, 18, 19, 20}, so the expected result will be 5.

Q2: I would like to visualize the distinct count of CONSUMER_ID have bought the cars like the UNION of Set1 + Set2 = {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,32,33,34,35}, so the expected result will be 30.

Q3: I would like to visualize the distinct count of CONSUMER_ID have bought the cars like the XOR of Set1 / Set2 = {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,21,22,23,24,25,26,32,33,34,35}, so the expected result will be 25.

Q4: I would like to visualize the distinct count of CONSUMER_ID have bought the cars like the DIFFERENCE of Set1 - Set2 = {21,22,23,24,25,26,32,33,34,35}, so the expected result will be 10.

Q5: I would like to visualize the distinct count of CONSUMER_ID have bought the cars like the DIFFERENCE of Set2 - Set1 = {1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}, so the expected result will be 15.

Can You complete the text obj on a bottom-right side of a sheet?

Thanks a looooooot

Paolo.

Re: How to use the operator of set analysis, using bookmarks

lironbaram — Wed, 03 Aug 2011 11:27:10 GMT

hei

attach is an example

for some reason the opertor of set analsys dont work

this is another way

hope its helps you

How to use the operator of set analysis, using bookmarks

rnepla83 — Wed, 03 Aug 2011 12:44:36 GMT

Very helpful Liron. Thanks a lot for the reply.

Thankssssssssssss

Paolo

topic How to use the operator of set analysis, using bookmarks in QlikView

How to use the operator of set analysis, using bookmarks

Re: How to use the operator of set analysis, using bookmarks

How to use the operator of set analysis, using bookmarks