Grouping elements within a Field

[#1]

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!

[rwunderlich]

Try creating a Calculated Dimension of:

=if(event='C', 'Churns', 'Active')

-Rob