Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
1 Solution

Accepted Solutions
felipedl
Partner - Specialist III
Partner - Specialist III

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.

Sample.png

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

Sample.png

Hope it helps.

Attached is the sample QVF file aslo.

Felipe. !

View solution in original post

1 Reply
felipedl
Partner - Specialist III
Partner - Specialist III

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.

Sample.png

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

Sample.png

Hope it helps.

Attached is the sample QVF file aslo.

Felipe. !