2 Replies Latest reply: Aug 3, 2011 8:44 AM by Paolo Rena RSS

    How to use the operator of set analysis, using bookmarks

    Paolo Rena

      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.