topic Re: Dynamic Need Repeat Value in QlikView

Dynamic Need Repeat Value

muniyandi — Tue, 01 Jul 2014 13:29:12 GMT

Hi,

i have one input box. user will enter the value . that time i need calculate.

Column() is slandered value.

Ex: User entered value is 5

I expected result is : Column(1)&Column(2)&Column(3)&Column(4)&Column(5)

i am using Straight chart. i need some expression.

Re: Dynamic Need Repeat Value

Tue, 01 Jul 2014 13:38:27 GMT

You can try writing expressions for the columns based on your need. Using a conditional enable, you can hide and show the required Columns. But in this case number of expressions will be equal to number of columns you wish to concatenate.

Re: Dynamic Need Repeat Value

muniyandi — Tue, 01 Jul 2014 13:43:14 GMT

now i handled in if condition .it's very huge. now i want to avoid the if condition .

Re: Dynamic Need Repeat Value

tresB — Tue, 01 Jul 2014 13:45:29 GMT

Like:

=$(=Pick(vColInput,'Column(1)','Column(1)&Column(2)','Column(1)&Column(2)&Column(3)','Column(1)&Column(2)&Column(3)&Column(4)','Column(1)&Column(2)&Column(3)&Column(4)&Column(5)'))

may be a simpler solution would be possible, but not yet struck.

Re: Re: Dynamic Need Repeat Value

Tue, 01 Jul 2014 13:46:55 GMT

Either you have to use If or you have to conditional enable multiple expressions. PFA the example. Hope it helps you.

Re: Re: Dynamic Need Repeat Value

muniyandi — Tue, 01 Jul 2014 13:56:37 GMT

Hi Tresesco & Deepak ,

Thanks for reply.

=$(=Pick(vColInput,'Column(1)','Column(1)&Column(2)','Column(1)&Column(2)&Column(3)','Column(1)&Column(2)&Column(3)&Column(4)','Column(1)&Column(2)&Column(3)&Column(4)&Column(5)'))

this expression also we are hard code the values,

i m expecting :

for loop method / Valueloop.

Re: Dynamic Need Repeat Value

PradeepReddy — Tue, 01 Jul 2014 14:05:30 GMT

Probably you can achieve this using Macros...