topic Graph intercept procedure in QlikView

Graph intercept procedure

Fri, 09 Sep 2011 15:54:31 GMT

Hi all,

I have a graph as the one shown in the picture. The slider below the graph generates a vertical line (in black) which moves in the graph.

Can anyone help me in finding a way to retrieve the intercept value between the black line and the green curve. Is there any function I should use?

I thought that I could interpolate the greenline curve equation and calculate the Y value according to the X position of the black line, but maybe there is a easy way to get this without interpolating the green line point.

Thanks!

This is the qv file.

Graph intercept procedure

Jason_Michaelides — Fri, 09 Sep 2011 16:00:00 GMT

Can you post your qvw so we can take a look?

Graph intercept procedure

Mon, 12 Sep 2011 16:06:03 GMT

Hi, I have posted the file. Thanks!

Graph intercept procedure

swuehl — Mon, 12 Sep 2011 16:50:12 GMT

Hi,

I think it is better to create / recreate your x-axis in the script, maybe like (untested):

INPUT:

LOAD

autonumberhash128 ( @5,@6 ) as [KeyVariable]

FROM

(txt, utf8, no labels, delimiter is '\t', msq);

OUTPUT:

LOAD

KeyVariable,

count(KeyVariable) as KVCount,

count(KeyVariable)+peek('KVCount') as KVCumCount

resident INPUT group by [KeyVariable];

I noticed that you have used an full accumulation in your graph, that's why I (tried) also to create a cumulated count.

So your expression in the text box could maybe look like:

sum(if(KVCount= scrollValue, KVCumCount)) / max(KVCumCount)

Everything untested, sorry.

Regards,

Stefan

Graph intercept procedure

Tue, 13 Sep 2011 15:10:00 GMT

Thanks a lot, it pointed me to the right direction!