topic Displaying field values in a Text Object in QlikView

Displaying field values in a Text Object

Anonymous — Tue, 15 Jul 2014 11:09:08 GMT

How do I write an expression in a text object to display the name of a salesperson for a specific region. I want the region in the text object to be fixed to 'Europe'.

Thanks

Greg

Re: Displaying field values in a Text Object

lvf — Tue, 15 Jul 2014 11:19:37 GMT

Try this....

=Concat({$<Region={'Europe'}>}SalesPerson, ' ')

Re: Displaying field values in a Text Object

tresB — Tue, 15 Jul 2014 11:22:45 GMT

With a distinct key, like:

=Concat({$<Region={'Europe'}>} Distinct SalesPerson, ' ,')

Re: Displaying field values in a Text Object

maxgro — Tue, 15 Jul 2014 11:26:02 GMT

=concat({$<region={Europe}>} distinct salesperson , chr(10))