topic Re: Expression Question in QlikView

Expression Question

Mon, 10 Oct 2016 15:53:15 GMT

Hi all,

I'm a bit challenged finding the correct expression for an assignment. I have attached a sample file to illustrate my problem.

Basically, I have a set of 12 orders in a table called ORDERS. Seven of the orders have delays in a table called ORDER_DELAY.

Delays can be either BUS or CLNT. ORDER_CDE is the key..

I need to be able to create a chart that shows all orders including ones with BUS delays but NOT CLNT delays. Please let me know an expression that will work. Even if I choose "select excluded' on the CLN T delay, it only brings back the 3 CUS delays but not the full result I am looking for. I've been stumped for several hours.

Any help would be greatly appreciated.

Thanks.

Don Saluga

Re: Expression Question

sunny_talwar — Mon, 10 Oct 2016 15:57:27 GMT

May be this:

Count(If(Delay <> 'CLNT', ORDER_CDE))

Re: Expression Question

sunny_talwar — Mon, 10 Oct 2016 16:00:00 GMT

Or this:

Count({<ORDER_CDE = {"=Delay <> 'CLNT' "}>} ORDER_CDE)

Re: Expression Question

Mon, 10 Oct 2016 16:03:48 GMT

Thanks again Sunny! I think you've helped me in the past. Can you please explain your logic? That's a bit tricky.

Re: Expression Question

sunny_talwar — Mon, 10 Oct 2016 16:09:05 GMT

Straight set analysis seems to misbehave when you have nulls due to the interaction of two tables. They are actually not nulls, but they are missing entries. So, something like this Delay -= {'CLNT'} won't work because Delay = Null doesn't even exists. But when we use a search string =Delay <> 'CLNT' against out unique identifier field ORDER_CDE we see the results. This is because we do have ORDER_CDE where Delay <> 'CLNT' and these includes places were we don't have any Delay information.

Does that make sense?

Re: Expression Question

Mon, 10 Oct 2016 16:10:35 GMT

Thank you very much. I think you enlightened the community as well. Good work. Thanks again for the fast service.

Re: Expression Question

sunny_talwar — Mon, 10 Oct 2016 16:13:09 GMT

I am glad I was able to help you out Don

Best,

Sunny