topic dynamic text box in QlikView

dynamic text box

NickHoff — Thu, 12 Feb 2015 16:06:19 GMT

I have two mapping loads, which can be found below.

Based on my mappings I want to create a dynamic text box that displays the revenue codes in if the user selects the RoomCategory or RoomType. I'd like to have the revenue codes displayed like 200, 201, 202, 203, ect.. dynamically..

MapRoomCategory:

MAPPING LOAD * INLINE [

RevenueCode, RoomType

200, ICU

201, ICU

202, ICU

203, ICU

204, ICU

205, ICU

207, ICU

208, ICU

209, ICU

206, Stepdown

210, ICU

211, ICU

212, ICU

213, ICU

215, ICU

216, ICU

217, ICU

218, ICU

219, ICU

214, Stepdown

];

MapRoomType:

MAPPING LOAD * INLINE [

RevenueCode, RoomType

200, ICU

201, ICU

202, ICU

203, ICU

204, ICU

205, ICU

207, ICU

208, ICU

209, ICU

206, ICUStepdown

210, CCU

211, CCU

212, CCU

213, CCU

215, CCU

216, CCU

217, CCU

218, CCU

219, CCU

214, CCUStepdown

];

Re: dynamic text box

rubenmarin — Thu, 12 Feb 2015 16:09:51 GMT

Hi Nick, if you are using this maps, in the load that applies the map has to load the code, create a field with this code.

If you have this code, the text box expression can be:

=Concat(RevenueCodeField, ', ')

Re: dynamic text box

NickHoff — Thu, 12 Feb 2015 16:28:14 GMT

The RevenueCode field is already in my data and =Concat(RevenueCode& ', ') doesn't work nor does =Concat(RevenueCode& '|')

I'm trying to get a list of all the revenue codes in my data, which fall in the RoomCategory mapping or RoomType mapping depending on what the user selects.

Re: dynamic text box

rubenmarin — Thu, 12 Feb 2015 16:31:46 GMT

Hi Nick, my concat has 2 parameters, first the field and second the separator, yours has only one parameter.

Yours can work but you need a blank space between 'RevenueCode' and '&'

Re: dynamic text box

NickHoff — Thu, 12 Feb 2015 16:37:40 GMT

Doesn't work, but i see the text object properties is repeating over and over.

Re: dynamic text box

rubenmarin — Thu, 12 Feb 2015 16:39:03 GMT

ok, and with?:

=Concat(DISTINCT RevenueCodeField, ', ')

Re: dynamic text box

NickHoff — Thu, 12 Feb 2015 16:55:51 GMT

Thanks Ruben.