topic Split the input box in QlikView

Split the input box

khadeer — Tue, 10 Jul 2012 16:51:36 GMT

I have dimension called model that has following value

i have put this above value in input box by using expression =concat(distinct model ,',')

but now i have to show two input boxes containing ax,ay,az and other input box should contain bx,by,bz.(on the basis of above condition i.e concat(distinct model ,','))

Re: Split the input box

MayilVahanan — Tue, 10 Jul 2012 17:02:16 GMT

Hi,

Try this,

= Concat({<model = {'ax','ay','az'} >} distinct model,',')

Same like Concat({<model = {'bx','by','bz'} >} distinct model,',')

or if you want all values start from 'a' means

= Concat({<model = {"a*"} >} distinct model,',')

for b, Concat({<model = {"b*"} >} distinct model,',')

Hope it helps