Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why the p funtion is not working on Qlik Sense?
It says that it isn't a valid function....
You might not need p() for this. You can try an expression like:
Count(DISTINCT {<Year={'$(=Max({<Prod>}Year)-1)'}>} Cust)
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
hi
p function is only used inside set analysis
for more information look here
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.
You might not need p() for this. You can try an expression like:
Count(DISTINCT {<Year={'$(=Max({<Prod>}Year)-1)'}>} Cust)