topic Re: P() Function Query in QlikView

P() Function Query

Tue, 26 Mar 2013 05:54:35 GMT

Hi All,

I have been working on this specific chart for hours and i have now resorted to Qlikcommunity for much needed help. I have attached a demo model which matched what i am trying to do. It is a rather complicated concept but what i am trying to do is bring back all possible CombinedCat's (field) no matter what i select.

Please let me know if i should explain any further, there is also an explanation in the model attached.

Thanks so much.

Re: P() Function Query

kaushiknsolanki — Tue, 26 Mar 2013 06:07:36 GMT

Hi,

Try below expression.

Sum({$<Product = , Presentation =, Strength =, Ingredient = , Manufacturer = , Category = , SubCategory = , Code = P({1<CombinedCat>}Code)>}Sales)

Hope this is what you want.

Regards,

Kaushik Solanki

Re: P() Function Query

Tue, 26 Mar 2013 07:43:06 GMT

Hi Kaushik,

I have applied this syntax. When making a selection, nothing changes. It is as if no selections have been made.

Re: P() Function Query

kaushiknsolanki — Tue, 26 Mar 2013 07:57:17 GMT

Hi,

Correct, this is because you have excluded every field in the expression.

As per me your expression should be like below.

Sum({$< Code = P({1<CombinedCat>}Code)>}Sales)

Regards,

Kaushik Solanki

Re: P() Function Query

Tue, 26 Mar 2013 08:26:04 GMT

Hi,

Thanks for your reply again. I have added the modified expression but it is still giving me wrong results. Please see attached the Demo model with your expression as SalesAttempt2.

If i select Product6 in the model it should show me Sales for Product6 and Product7 because they are under the same CombinedCat.

Do you understand my probem?

Sorry for the hassle.

Re: P() Function Query

kaushiknsolanki — Tue, 26 Mar 2013 09:00:49 GMT

Hi,

Try this expression.

Sum({$< CombinedCat = P(CombinedCat),Product=>}Sales)

Regards,

Kaushik Solanki

Re: P() Function Query

Tue, 26 Mar 2013 09:05:03 GMT

Thank you Kaushik,

Works perfectly!!