How to use IN operator in Qlikview

[#1]

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

[CELAMBARASAN]

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)

[IAMDV]

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,

DV

www.QlikShare.com

Deepak Vadithala

[Anonymous]

Outstanding observation !

Thanks from the blind ones.