topic Re: Values for comma seperated values.. in QlikView

Values for comma seperated values..

Thu, 16 Apr 2015 16:26:16 GMT

Hi,

I need help with following question.

I have many records in 'Account numbers'... like 10000 to 50000..

when we search the records with comma seperated value for e.g '10005,10115,45990,48900'. we should get the records for only that 4 'Account numbers.'

Please let me know your idea in detail as to how to achieve this..

Appreciate all the help..

Thanks

Re: Values for comma seperated values..

Thu, 16 Apr 2015 16:35:11 GMT

You context of the Question is not clear.. where are you searching? Are you loading the Qlikview Script. Please throw some more details or post the sample app.

Re: Values for comma seperated values..

Gabriel — Thu, 16 Apr 2015 16:35:53 GMT

Hi,

You would have to use Replace function to replace the commas (,) to pipe (|),

i.e

=Replace('10005,10115,45990,48900',',','|')

See if this helps

Re: Values for comma seperated values..

stigchel — Thu, 16 Apr 2015 16:36:24 GMT

Have a look at the following article, I think you need the compound search so with brackets and a pipeline delimiter to use in a search object, which you can add to the sheet for this field.

e.g.

(10005|10115|45990)

The Search String

Re: Values for comma seperated values..

MK_QSL — Thu, 16 Apr 2015 16:39:19 GMT

Go to Google

Search QlikFix

Search by Copy and Pasting From an External List

Might be useful for you..

Re: Values for comma seperated values..

Thu, 16 Apr 2015 17:39:08 GMT

Thanks Manish.. That Article was useful..

Re: Values for comma seperated values..

Thu, 16 Apr 2015 17:47:09 GMT

Thanks.. Your info was helpful..