3 Replies Latest reply: Aug 8, 2011 5:41 AM by jenark81 RSS

    Excluding values from Expressions

      I'm very new to Qlikview, so newbie apologies


      I have a field in my data called P/N. The values in the field for each row of data are either P, N or E. I would like to draw a pie chart but excluding the Es (i.e. it will have two segments, either P or N)


      I've started with my Expression as    TextCount ([P/N])  but I'm not sure how to go about excluding all the Es.


      Any assistance would be very appreciated.