1 Reply Latest reply: Jul 16, 2013 10:24 PM by Rob Wunderlich RSS

    Grouping elements within a Field

      Hello,

       

      In my table, I have a field called event that contains the value of either 'P', 'C', or 'U'.

       

      I would like to make a line graph that shows my data with 2 lines-->

      One line would display only the data where the field event = 'C'  and would be labeled as 'Churns'

      The 2nd line would contain all the data where event = 'P' and event = 'U' and would be labeled as 'Actives'.

       

      When I select the event field as a dimension it gives me 3 lines, one for each P, C and U.

       

      Can anybody help me figure out how to group it this way??

       

      I have tried creating some Calculated Dimension but I am new to qlikview and very confused.

       

      Thanks!