Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Partner
Partner

How to use the operator of set analysis, using bookmarks

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.

1 Solution

Accepted Solutions
Partner
Partner

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

hei

attach is an example

for some reason the opertor of set analsys dont work

this is another way

hope its helps you

2 Replies
Partner
Partner

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

hei

attach is an example

for some reason the opertor of set analsys dont work

this is another way

hope its helps you

Partner
Partner

How to use the operator of set analysis, using bookmarks

Very helpful Liron. Thanks a lot for the reply.

Thankssssssssssss

Paolo