Thanks for your quick response but there is a problem after i am implementing this logic.
I had the order table data as
Order Id Order ID
29 needed output -->
Now as per your logic : In expression :
Now what is happening ,In the report where the order id id dispayed ...the output is coming like this..
25 - 25
I dont know the reason..please throw some light
This depends on where you want to include the in values. If it is just in a text object or display object then using:
But if you want to create an expression and only want the values of those 3 orders used in that expression then you would use set analysis in the expression like this:
Hope this helps!
QlikView has a function called EXISTS. May be worth trying it.
EXISTS( field [ , expr ] )
Determines whether a specific field value exists in a specified field
of the data loaded so far. Field is a name or a string expression evaluating
to a field name. The field must exist in the data loaded so far
by the script. Expr is an expression evaluating to the field value to
look for in the specified field. If omitted, the current record’s value
in the specified field will be assumed.
EXISTS( Month, 'Jan' )
returns -1 (true) if the field value Jan can be found in the
current contents of the field Month.