topic Re: Select articles in QlikView

Select articles

Thu, 15 Jun 2017 13:11:15 GMT

Hello,

I want to select a range of articles, for example Article number 500 untill 510.

The Tablename is INV1, the fieldname is Itemcode.

How can I do this in a column field?

Regards,

Leon

Re: Select articles

jaumecf23 — Fri, 30 Jun 2017 09:58:57 GMT

I supose that you want to do that in the script. You can do something like this:

Load

Itemcode,

[Article number]

Resident INV1

where Itemcode>= 500 and Itemcode<=510;

Re: Select articles

rittermd — Fri, 30 Jun 2017 12:10:31 GMT

If you want to have this data in the application but want to filter this in your visualization then you need to use set analysis in your Dimension instead of just picking this field as your extension. I am assuming that Itemcode is the Dimension.

Re: Select articles

Fri, 30 Jun 2017 12:21:56 GMT

Thank you for the help, I will try the script as well as the set analysis

Re: Select articles

rittermd — Fri, 30 Jun 2017 12:27:58 GMT

If you do it in your load script then that range of Itemcodes will be the only data that makes it into your app. If you load all of your data and use Set Analysis then you can limit what data is displayed in the chart but it is all available.

Re: Select articles

agigliotti — Fri, 30 Jun 2017 12:29:00 GMT

you can use set analysis in measure as well.