topic Calculated Dimension Showing ONLY Possible Customers in QlikView

Calculated Dimension Showing ONLY Possible Customers

Tue, 08 Mar 2011 23:34:42 GMT

I have a population of Clients and Salespeople.

In my calculated dimension, I'd like to only show the Clients that have Sales with only Salespeople A and B.

I'm thinking of using the p function but am having problems with the syntax. Can anybody advise? Thanks in advance!

pljsoftware — Tue, 08 Mar 2011 23:55:09 GMT

Hi Henry,

try to create a pivot table with dimension Clients and expression

sum( {<Salespeople={'A', 'B'}>} Sales)

Regards
Luca

Wed, 09 Mar 2011 00:08:41 GMT

Hi Henry,

try this:
element_function ::= ( P | E ) ( [ set_expression ] [ field_name ] )

thanks