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

    Grouping elements within a Field



      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.