topic exists function -- Need urgent help plz in QlikView

exists function -- Need urgent help plz

Tue, 02 Jul 2013 13:56:12 GMT

Hi All,

I have a requirement in order management.I have some SP orders which are booked in advance but not yet confirmed.So for this orders we have orderentereddate and orderconfirmdate.This orders will flow into my open,closed and cancel data.Lets say an order has chnaged from SP to Closed order directly for this order i need to use the Orderconfirmdate instead of orderentereddate.

For this I am loading the SP orders (lets say some 30 orders)data first and then I am loading my closed orders date(10000) in to two sets like 1.where data exists in SP orders.2 does not exists in SP orders.

But this way i am not able to achieve my requerment.

Can some one suggest me if i am wrong any where.Kindly let me know if you need more info.

Thanks in advance.

Re: exists function -- Need urgent help plz

swuehl — Tue, 02 Jul 2013 14:12:52 GMT

Sorry, I can't follow you. Don't really know your requirement, how you tried to achieve your requirement (test data, script code) and why this doesn't work for you (what you get, what you expect instead).

Please try creating some sample lines of data and try to create your expected output from that.

Re: exists function -- Need urgent help plz

IAMDV — Tue, 02 Jul 2013 14:15:52 GMT

Hi Lavanya,

I hope you're doing well. As Stefan mentioned, please provide sample data. It's hard to follow now.

Cheers,

www.QlikShare.com

Re: exists function -- Need urgent help plz

Wed, 03 Jul 2013 09:48:21 GMT

Hi All,

Thanks for ur reponse.I have made the logic work using Apply Map() instead of Exists().

Regards,

Lavanya

Re: exists function -- Need urgent help plz

Wed, 03 Jul 2013 10:09:31 GMT

Hi All,

Thanks for ur reponse.I have made the logic work using Apply Map() instead of Exists().

Regards,

Lavanya

Re: exists function -- Need urgent help plz

Wed, 03 Jul 2013 10:10:53 GMT

Hi All,

Thanks for ur reponse.I have made the logic work using Apply Map() instead of Exists

Regards,

Lavanya