Re: Re: How to use IN operator in Qlikview - Page 2 - Qlik Community

Report Inappropriate Content · ‎2012-09-25

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 · ‎2013-10-09

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 · ‎2013-10-09

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

Anonymous · ‎2013-10-09

Outstanding observation !

Thanks from the blind ones.