Controlling the existence in a values set

Mon, 18 Apr 2011 13:59:21 GMT

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

Controlling the existence in a values set

erichshiino — Mon, 18 Apr 2011 14:14:34 GMT

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);

topic Controlling the existence in a values set in QlikView

Controlling the existence in a values set

Controlling the existence in a values set