P() function

[Carlaf_93]

Why the p funtion is not working on Qlik Sense?

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

[rzenere_avvale]

Goodmorning @Carlaf_93 ,

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

[lironbaram]

hi 

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/...

[Carlaf_93]

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.

[tresesco · Accepted solution]

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

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