topic Re: Text Object Box in QlikView

Text Object Box

evansabres — Wed, 17 Jun 2015 14:17:49 GMT

Hello -

I have a text object box in which I have the field 'cmpMNTH' representing a campaign month. When I make a selection, my desired return is to have that text object box say the month the campaign started. However, for certain categories, there may be multiple months that could be returned. Is there a way to have the box essentially have an if statement, so that when there is more than one month, the box either returns, multiple or Jan, Mar, Aug?

Not sure if this is possible.

Thank you,

Evan

Re: Text Object Box

sunny_talwar — Wed, 17 Jun 2015 14:20:55 GMT

May be use this:

=Concat(DISTINCT cmpMNTH, ',')

Re: Text Object Box

stigchel — Wed, 17 Jun 2015 14:21:24 GMT

You can use the Concat function for this e.g.

=Concat(DISTINCT cmpMNTH,',')

Re: Text Object Box

evansabres — Wed, 17 Jun 2015 14:24:12 GMT

Thank you, this helped.

Re: Text Object Box

evansabres — Wed, 17 Jun 2015 14:24:21 GMT

Thank you, this helped.