Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

reference line query

i would like to know is it possible to add a reference line for each month in the chart.

lets say the dimension is [month year] so i would like to add a reference line for each month.

i have tried reference line option for bar/combo charts thats not what am looking for.

i want the reference line to go for each month, it may be continuous lines with its own peak up and down or could be broken lines for each month.

or plz suggest if there is any extension that i can use

thanks

7 Replies

Re: reference line query

Hi,

You need to add the reference data in load script.

Something like attached.

Regards,

Kaushik Solanki

Not applicable

Re: reference line query

i need qvf file not qvw..using qlik sense

vikasmahajan
Honored Contributor III

Re: reference line query

It seems it is not available in Sense I am also searching for the same.

Go through this thread Re: Reference line in combo chart ?

Vikas

arulsettu
Honored Contributor III

Re: reference line query

like this?

Untitled.png

vikasmahajan
Honored Contributor III

Re: reference line query

Arul Can you share qvf  and tell us whether it is possible ? , I want vertical reference lines.

Vikas

Re: reference line query

Hi,

Sorry My Bad.

In QlikSense you may find a sample document named "Consumer Sales". In that Application go to Budget Analysis.

Here you will see actual vs budget chart. Do you need chart like this. In your case Budget will be the reference value.

Capture.PNG

Regards,

kaushik Solanki

Not applicable

Re: reference line query

Hi Vikas,

As you are expecting a different value for every month year, this could be possible only if you have reference data for each month or I can say Target for each month year, So above method will work. Can you show any picture ruffly so we know exactly what exactly your requirement ?

Community Browser