Values for comma seperated values..

[#1]

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

[#2]

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.

[Gabriel]

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

[stigchel · Accepted solution]

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

[MK_QSL]

Go to Google

Search QlikFix

Search

Search by Copy and Pasting From an External List

Might be useful for you..

[#6]

Thanks Manish.. That Article was useful..

[#7]

Thanks.. Your info was helpful..