6 Replies Latest reply: Aug 14, 2014 7:10 AM by Anthony Griffiths RSS

    Using the P function right?

      Hi,

       

      Still fairly new to using Qlikview and struggling with a few things

       

      I have two charts next to eachother, one highlighing RR data and the other EMS data (CostCentre_Activity = 'RR')

       

      When i drill down in the EMS data it turns the RR data to 'No data to display' which I would expect. Is there a way to stop this from happening?

       

      I seen that you can use the P function

       

      So, i tried it like this:

       

      avg({1<CostCentre_Activity=P(CostCentre_Activity)>}PMF_Score)

       

      Is there a way to make it read something like this: avg({1<CostCentre_Activity=P(CostCentre_Activity={RR})>}PMF_Score)

       

      Or am I barking up the wrong tree? Is there no way to include a filter value into a P function

       

      Thanks for your help in advance

       

      Ant