Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
d_petkovic
New Contributor

Reference line depending on date

Hello together,

I would like to add a reference line vertically, depending on the date in the x-axis. The date is formatted as 11.2018 (November 2018).

What expression or formula I have to use or how can I set this reference line?

 

Thank you in advance for your help!

 

6 Replies

Re: Reference line depending on date

Which Chart?
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
d_petkovic
New Contributor

Re: Reference line depending on date

It's a vizlib Line Chart.

Re: Reference line depending on date

Try this?

FieldName = '11.2018'

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
d_petkovic
New Contributor

Re: Reference line depending on date

It doesn't work probably.
I just want to use the criteria "Date" to show this additional line vertically above the date.

Example: If the date starts at February 2018 (02.2018) the line should show up above. If the date changes to May 2018 (05.2018) the line should switch an show up above May.

ericapaiva
New Contributor

Re: Reference line depending on date

You can try to use MakeDate(year,  month, day)

Re: Reference line depending on date

What is the logic behind to bring dynamic?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)