topic Re: Need help on P function in QlikView

Need help on P function

Fri, 07 Mar 2014 19:45:44 GMT

Dear all,

My code is not working. Any thoughts on why?

=sum( {$<[MEMBER ID] = P({1<[SERIE TITLE]={‘Castle’}>} [MEMBER ID])>}PRICE)

I am trying to get a list of series that people have seen who have also seen the serie Castle.

All help is appreciated!

Re: Need help on P function

jerem1234 — Fri, 07 Mar 2014 20:01:11 GMT

The syntax of the formula seems correct. Whether or not this is the correct formula to use, I can't be sure. It seems like the p() function should get you want you want. Would you be able to post an example app, demonstrating the problem? Or some small example of what the data looks like, and what your expected output is.

Update: Also, make sure all your field names are correct.

Hope this helps!

Re: Need help on P function

Sat, 08 Mar 2014 10:31:16 GMT

My whole qlikview app is very large. So I made an overview of what I am trying to accomplish and a field overview (see attachment). Does this give you more info?

Re: Need help on P function

swuehl — Sat, 08 Mar 2014 10:49:39 GMT

Take care of that current selections still influence your working set

=sum( {$<[MEMBER ID] = P({1<[SERIE TITLE]={‘Castle’}>} [MEMBER ID])>}PRICE)

you set member ID here, but a selection in serie title will still limit your result. So maybe clear the selection in serie title if needed:

=sum( {$<[MEMBER ID] = P({1<[SERIE TITLE]={‘Castle’}>} [MEMBER ID]), [SERIE TITLE]= >}PRICE)

or use a different set identifier:

=sum( {1<[MEMBER ID] = P({1<[SERIE TITLE]={‘Castle’}>} [MEMBER ID])>}PRICE)

Re: Need help on P function

Sat, 08 Mar 2014 11:13:19 GMT

Thanks for your feedback!

But I really have no clue how to solve this. So I copied my app and deleted some tabs. Hopefully this will give you more info...

Could you please give me feedback in text as a use a personal edition...

Re: Need help on P function

swuehl — Sat, 08 Mar 2014 11:26:36 GMT

Ok, I think there are two issues, you've used the wrong type of quotes, then you need to clear the selection in title

=sum( {$<[MEMBER ID] = P({1<[SERIE TITLE]={'Castle'}>} [MEMBER ID]),[SERIE TITLE]=>}PRICE)

a generalized expression could look like

=sum( {$<[MEMBER ID] = P(),[SERIE TITLE]=>}PRICE)

Re: Need help on P function

Sat, 08 Mar 2014 18:39:30 GMT

Yeah Swuchi, it works!!!! Thank you!