topic p() in a calculated field dimension in QlikView

p() in a calculated field dimension

tinkerz1 — Wed, 14 Oct 2015 07:51:37 GMT

have this code it my calcluated dimension:

if([Group]=LIVE,[Group])

I would like to try

if([Group]=P({1} ABD::LIVE),[Group])

use the P() term and use a Alternate States selection.

Also in a field list can you set the selection to only 1 field can be selected

avinashelite — Wed, 14 Oct 2015 07:52:47 GMT

p() work only with the set analysis

Anonymous — Wed, 14 Oct 2015 07:58:04 GMT

P() works in Set Analysis only not at IF level.

You are asking for One value selection in a field or one field from multiple field list?