Controlling the existence in a values set

[#1]

Hi,

I need to control that a dimension value is or not in a set of predefined values. Fe, in SQL Server I could write myNumericField IN (0, 1, 2, 3). In QV, how can I write a similar statement?

Thanks

[erichshiino]

You can create you set in a inline statement.

After that, use where exists() to load only the values already in the reference set. Your code would look like this:

Reference:
LOAD * INLINE [
myField
0
1
2
3
];

Load * from [...]
where exists(myField);