topic Quick data selections with external data in QlikView

Quick data selections with external data

qlikviewalex — Tue, 11 Aug 2015 13:26:51 GMT

Hi,

in my QlikView I control nearly 50 000 products. So I have tables like this:

Id.number	Name	Price	Costumer
123	P1	12.45	Müller
456	P2	10.57	Schmied
...	...	...	...

Now I get a list with 20 to1000 Id.numbers. The Numbers can be in an Excel file or a Mail.

My problem is how can I get all numbers at once in my Id.number filter?

I tried a Inputfield in my Script and a Input Box in my Layout with a Variable. But nothing works correct, if I had to much Id.numbers for my selection.

Has anyone a idea or a solution for my problem.

Thanks

Alex

Re: Quick data selections with external data

marcus_sommer — Tue, 11 Aug 2015 13:40:11 GMT

See here Re: Inputbox not more then 25000 Char's and here Re: flexible Variablen.

- Marcus

Re: Quick data selections with external data

qlikviewalex — Thu, 13 Aug 2015 07:26:31 GMT

Thanks.

Re: Inputbox not more then 25000 Char's

This link was very good.

It works well.

Alex