topic Re: Multiple values pasting from excel to Input box issue in QlikView

Multiple values pasting from excel to Input box issue

Tue, 09 May 2017 07:22:20 GMT

Hi All,

i have a issue Doing multiple selection pasting in Input box and searching using a button..

please find the attachment:

Excel File Like

When i am copying this cells from excel and pasting in QV- Input box it's showing like "1 2 " Each cell ending with Double Spaces.

Can anyone help me this asap.

Thanks,

Surya.

Re: Multiple values pasting from excel to Input box issue

prieper — Tue, 09 May 2017 07:34:01 GMT

Think that you need to cover the linebreak as well.

Please try something like

'(' & REPLACE(REPLACE(REPLACE(TRIM('$(vSearchProduct)'), ' ', '|'),' ', '|'), CHR(10), '|') & ')'

Peter

Re: Multiple values pasting from excel to Input box issue

RonaldDoes — Tue, 09 May 2017 08:16:00 GMT

Hi Surya,

I've tested this and found out that a combination of CR and LF work (with my Excel/QV12).

='(' & REPLACE(REPLACE(REPLACE(TRIM('$(vSearch)'), '  ', '|'),' ', '|'), CHR(10)&CHR(13), '|') & ')'

Please find the QVW attached.

Re: Multiple values pasting from excel to Input box issue

Tue, 09 May 2017 08:59:23 GMT

Hi Peter,

Thanks for your reply..

When i am Copy 1 and 13 and pasted in Input box it's not working..

Thanks.

Surya

Re: Multiple values pasting from excel to Input box issue

Tue, 09 May 2017 08:59:41 GMT

Hi Ronald,

Thanks for your reply..

When i am Copy 1 and 13 and pasted in Input box it's not working..

Thanks.

Surya

Re: Multiple values pasting from excel to Input box issue

RonaldDoes — Tue, 09 May 2017 09:04:39 GMT

What does the text box say when you do so?

Re: Multiple values pasting from excel to Input box issue

Tue, 09 May 2017 09:08:04 GMT

you Just Give in input box "2 13 ". you will be know my issue ronald..

Re: Multiple values pasting from excel to Input box issue

RonaldDoes — Tue, 09 May 2017 09:10:46 GMT

That gives the below result. Is that not what you are expecting?

Re: Multiple values pasting from excel to Input box issue

Tue, 09 May 2017 09:28:59 GMT

I want show green color of Product Name also.. Can you please help me .

Re: Multiple values pasting from excel to Input box issue

Tue, 09 May 2017 09:39:09 GMT

Product also need to associate with green color . We can see Input box as Product that's needs to be associated data...

Re: Multiple values pasting from excel to Input box issue

Tue, 09 May 2017 09:42:55 GMT

if you above image attached your reply.. Search fro product is Empty..That also need Ronald..

Thanks,

Surya..

Re: Multiple values pasting from excel to Input box issue

RonaldDoes — Tue, 09 May 2017 09:43:39 GMT

Hi Surya,

The products associated with the selected (green) suppliers are correctly shown in white.

If you were te search for a product, the selected product would show in green.

For more info on qlikview selection behaviour, I would like to refer you to the excellent explanation here: https://www.google.nl/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0ahUKEwjg26H1wuLTAhXqCcAKHdV4D_sQFggvM…