topic Re: P() function in Management & Governance

P() function

Carlaf_93 — Sat, 16 Nov 2024 02:12:00 GMT

Why the p funtion is not working on Qlik Sense?

It says that it isn't a valid function....

Re: P() function

rzenere_avvale — Tue, 09 Jun 2020 08:21:58 GMT

how are you trying to use it? Would you mind sharing an example of what you're trying to do?
I've used it on almost all QS versions without issues

Many thanks,
Riccardo

Re: P() function

lironbaram — Tue, 09 Jun 2020 08:25:10 GMT

p function is only used inside set analysis

for more information look here

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-modifiers-implicit-field-value-definitions.htm

Re: P() function

Carlaf_93 — Tue, 09 Jun 2020 08:41:30 GMT

i woul like too see how many actual customers bought someting last year.

So i want to create a kpi that says if a selected customers bought something last year.

Re: P() function

tresB — Tue, 09 Jun 2020 10:25:15 GMT

You might not need p() for this. You can try an expression like:

Count(DISTINCT {<Year={'$(=Max({<Prod>}Year)-1)'}>} Cust)