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.