topic Re: Using the P function right? in QlikView

Using the P function right?

Thu, 14 Aug 2014 10:40:03 GMT

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

tresB — Thu, 14 Aug 2014 10:44:11 GMT

Try like:

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

Thu, 14 Aug 2014 10:51:15 GMT

It kind of worked, my drill down is PM -> FLM (So multiple FLM's under 1 PM, and 6 PM's for RR)

With that expression, it drills down to all of the FLMs, regardless of which PM i select

tresB — Thu, 14 Aug 2014 10:54:30 GMT

Ohh, I should have read more carefully, 'RR' is a field. Try:

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

Thu, 14 Aug 2014 10:56:52 GMT

Thank you

tresB — Thu, 14 Aug 2014 11:00:29 GMT

Did that work? Then please mark it 'Correct Answer' to close the thread.

Thu, 14 Aug 2014 11:10:39 GMT

No it didn't unfortunately, the "=RR" didn't work

I've tried using Alternate states as well which sort of works as well but I can't seem to drill down once they're in a state