8 Replies Latest reply: Mar 12, 2013 10:10 AM by Fabio Vallone RSS

    Set analysis ?

    Fabio Vallone

      Hi,

       

        I'm trying to create a table in QlikView, with some conditions: I have a QVD with several

      events, each event from one client, like this:

       

      Client   Event   Qtd

        A           01     10

        A          02      5

        A          03      8

        B          01      5

        B          03      2

        ...

       

        I want to compare the event number "01" with the other events:

       

       

      Client  Event (=01)   Others (<>01)    Others/Event#01

         A           10                   50                          5,0

         B            5                     2                           0,4

       

       

        So, I tried to put Set Analysis like this:

       

         = Sum( {$<Event={'01'}>} Qtd) , but doesn't work (because the Event "01" is not selected, just Event "04")

         = Sum( {1<Event={'01'}>} Qtd) , but doesn't work too (in this case, all clients get "all" events #01- the same number for all clients)

       

        How can I solve it ??

       

       

      Thanks,

       

      Fabio.