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

    Using the P function right?



      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:




      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