topic Determining intersection date of two Expressions in QlikView

Determining intersection date of two Expressions

Fri, 29 Mar 2013 22:53:55 GMT

I've got two Expressions charted on a line chart. I want the date on which the 2nd Expression is >= the 1st Expression, which I will then display in a Straight Table. I've created a simplified example below. Hoping someone can tell me how to create an Expression for my Straight table that will return this date.

First Expression is:

TOTAL_TB - (TOTAL_TB * 0.25)

Second is simply:

T30_AVG_USED_TB

SAMPLE TABLE::

DISC_DATE	TOTAL_TB	AVG_USED_TB
2003-01-02	150	100
2003-01-03	150	109
2003-01-04	150	120
2003-01-05	150	125
2003-01-06	150	133

In this example I would want 2003-01-04, as the first expression calculates out to 112.5, hence 120 is first occurance of AVG_USED_TB >= 112.5.

Re: Determining intersection date of two Expressions

udit_kumar_sana — Sat, 30 Mar 2013 09:53:38 GMT

Hi ,

Please find here the attached file for the solution.

Regards,

Udit

Re: Determining intersection date of two Expressions

Sat, 30 Mar 2013 13:33:11 GMT

Hello Udit,

Thanks for your response and sample solution. I understand what you are doing here, but does not fully solve my problem as I only want to display the Intersection Date in my Straight Table and nothing else. Any ideas?

Thanks,

Lew

Re: Determining intersection date of two Expressions

udit_kumar_sana — Sat, 30 Mar 2013 15:51:11 GMT

Hi,

Please see the attached file.

-Hide the two expression column from presentation tab of straight table by choosing hide column option available.

Regards,

Udit,

Re: Determining intersection date of two Expressions

Sun, 31 Mar 2013 00:53:05 GMT

Thanks! This did the trick!

Best Regards,

Lew