topic Re: How to use IN operator in Qlikview in QlikView

How to use IN operator in Qlikview

Tue, 25 Sep 2012 11:08:37 GMT

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

Re: How to use IN operator in Qlikview

rajni_batra — Tue, 25 Sep 2012 11:11:23 GMT

=if(match(Order,24,25,26),Order or any other value)

Re: How to use IN operator in Qlikview

Tue, 25 Sep 2012 11:22:30 GMT

Hi Rajni,

Upto If(Match(order,24,25,26) i got to know but after that 'Order or any other value'....wat is dat???

Re: How to use IN operator in Qlikview

rajni_batra — Tue, 25 Sep 2012 11:25:49 GMT

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!!!

Re: How to use IN operator in Qlikview

Tue, 25 Sep 2012 11:46:59 GMT

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

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

25 - 25

26- 26

27- 27

I dont know the reason..please throw some light

Re: How to use IN operator in Qlikview

rajni_batra — Tue, 25 Sep 2012 11:49:24 GMT

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??

Re: How to use IN operator in Qlikview

jaime_aguilar — Tue, 25 Sep 2012 14:47:45 GMT

You can use a resident table for displaying the desired Order IDs:

ORDERS:

LOAD * INLINE [

OrderID

];

MATCH:

load *,

if(match(OrderID, 25,26,27), OrderID) as output

Resident ORDERS;

Re: How to use IN operator in Qlikview

Thu, 18 Oct 2012 15:50:15 GMT

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!

Re: How to use IN operator in Qlikview

Gabriel — Wed, 24 Oct 2012 10:44:31 GMT

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

Re: How to use IN operator in Qlikview

Wed, 09 Oct 2013 20:41:58 GMT

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.

Re: How to use IN operator in Qlikview

CELAMBARASAN — Wed, 09 Oct 2013 20:47:24 GMT

If your are going to display sales for some order id then you can use Sum({<OrderID={25,26,27}>} Sales)

Or If you want display orderID itself then you can use

Only({<OrderID={25,26,27}>} Sales)

Re: Re: How to use IN operator in Qlikview

IAMDV — Wed, 09 Oct 2013 21:15:16 GMT

Guys - You're replying back to a thread which is more than one year old! I'm sure Abdul would have solved this long back.

Cheers,

www.QlikShare.com

Deepak Vadithala

Re: How to use IN operator in Qlikview

Anonymous — Wed, 09 Oct 2013 23:07:24 GMT

Outstanding observation !

Thanks from the blind ones.