?

xyz1 — Sun, 14 Apr 2019 15:47:50 GMT

Re: Reference Line by Dimension

felipedl — Mon, 23 Oct 2017 13:57:15 GMT

Hi Agrim,

You can't put a straight vertical line directly in Qlik Sense, you'd have to use a workaround with your data on it.

As an example, using the code bellow:

data:

load * inline

[

A,B

10/23/2017,100

10/24/2017,101

10/25/2017,105

10/26/2017,195

10/01/2017,1

01/01/2017,100

01/02/2017,200

];

test:

load

max(B) as maxValue

Resident data;

left join (data)

load

Today() as A,

maxValue as C

Resident test;

drop table test;

Will get the reference line based on today's date and gets the max value from your dataset so that you can create a combo chart, having the lines as you have on your images, and an additional expression with a bar, that would be your reference line, giving the following result.

Adding more data to it, you'll get something like:

Hope it helps.

Attached is the sample QVF file aslo.

Felipe. !

topic Re: Reference Line by Dimension in QlikView

?

Re: Reference Line by Dimension