Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
actually i had a table in which i got various order values but i want to display only those orders which are 24,26, & 27.
In Sql we can use IN operator for that.
Please help me here how to use it.
Thanks
=if(match(Order,24,25,26),Order or any other value)
Hi Rajni,
Upto If(Match(order,24,25,26) i got to know but after that 'Order or any other value'....wat is dat???
means u want to display only orders then use orders if in case u want to display something else for respective these order no. then u can use the same
like if u want to show sales office for these orders then use
if(match(Order,24,25,26),Sales Office)
Hope it would be helpful!!!
Hi Rajni,
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
24 25
25 26
26 27
27
28
29 needed output -->
Now as per your logic : In expression :
If(match(orderId,25,26,27),OrderId)
Now what is happening ,In the report where the order id id dispayed ...the output is coming like this..
OrderID
24
25 - 25
26- 26
27- 27
28
29
I dont know the reason..please throw some light
may i know where did u put this expression??
if u are using it in a report so better use this as dimension in ur table or using some other Object??
You can use a resident table for displaying the desired Order IDs:
ORDERS:
LOAD * INLINE [
OrderID
24
25
26
27
28
29
];
MATCH:
load *,
if(match(OrderID, 25,26,27), OrderID) as output
Resident ORDERS;
This depends on where you want to include the in values. If it is just in a text object or display object then using:
=if(Match(Order,24,26,27),Order)
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:
sum({<Order={'24','26','27'}>}(TotalSales))
Hope this helps!
Hi,
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.
Examples:
EXISTS( Month, 'Jan' )
returns -1 (true) if the field value Jan can be found in the
current contents of the field Month.
Regards
You need to specify.. where you want to use the values.. as expression or dimension. lo_arron has already answered it. If you could clarify it. we can try and get back to you soon. OR you can share the application and requirement, we will surely try helping you.