Select articles

[#1]

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

[jaumecf23]

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;

[rittermd]

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.

[#4]

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

[rittermd]

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.

[agigliotti]

you can use set analysis in measure as well.