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?
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);
Retrieving data ...