topic Re: P() function in QlikView 12 in QlikView

P() function in QlikView 12

kclayton1 — Wed, 25 Nov 2020 16:16:04 GMT

Did the p() function get removed in QlikView version 12 or higher?

Thanks.

Kevin

Re: P() function in QlikView 12

oknotsen — Fri, 06 May 2016 20:12:22 GMT

I just checked some files made in QV11.2 with the P() function. Opened them in QV12 and the results look the same. No error.

So no, seems like it has not been removed.

Btw, there is no higher version since QV12.

Re: P() function in QlikView 12

swuehl — Fri, 06 May 2016 20:13:58 GMT

What make you think it has been removed?

Re: P() function in QlikView 12

sunny_talwar — Fri, 06 May 2016 20:14:59 GMT

Its still there, use it all the time. I am using QV12

Re: P() function in QlikView 12

kclayton1 — Fri, 06 May 2016 20:15:19 GMT

I did not see it in the function list and the syntax checker throws an error.

Re: P() function in QlikView 12

oknotsen — Fri, 06 May 2016 20:22:33 GMT

Sounds like a new and an old bug.

Syntax checker has had problems with (more complex) Set Analysis since forever (I think; didn't check though I am sure for at least QV11.0). Not being listed sounds like a nice sweet new little bug.

Re: P() function in QlikView 12

sunny_talwar — Fri, 06 May 2016 20:24:30 GMT

I don't see any syntax error here

Might be due to something else you might have. Can you share your expression?

Re: P() function in QlikView 12

swuehl — Fri, 06 May 2016 20:28:02 GMT

Which function list are you referring to?

p() function can only be used within a set expression's field modifier, i.e. using set analysis.

Re: P() function in QlikView 12

kclayton1 — Fri, 06 May 2016 20:38:26 GMT

Good point. I had an error in my expression. Thanks.

Re: P() function in QlikView 12

kclayton1 — Fri, 06 May 2016 20:41:19 GMT

Thanks. I was looking in the function list under the expression window. I forgot that I would not find it there. Thank you for your help.

Re: P() function in QlikView 12

swuehl — Fri, 06 May 2016 20:48:38 GMT

There is an error indicated if you leave out the field name

This is an error of the error checker. The syntax is valid.