topic Re: Reference line in the chart in QlikView

Reference line in the chart

Tue, 18 Mar 2014 13:25:27 GMT

Hi All,

I want to show a reference line vertically in the chart when an event occurs in the particular month. PFA

Re: Reference line in the chart

ThornOfCrowns — Tue, 18 Mar 2014 13:28:20 GMT

Can you give an example of the event that wouod trigger the "reference line"?

Re: Reference line in the chart

jonathandienst — Tue, 18 Mar 2014 13:30:20 GMT

For a vertical reference line, you need to enable continuous mode for the x-axis (Properties | Axes).

HTH

Jonathan

Re: Reference line in the chart

Tue, 18 Mar 2014 13:36:06 GMT

HI jonathan,

i want to display the events as reference lines at that respective month how can i get that??

Re: Reference line in the chart

veidlburkhard — Tue, 18 Mar 2014 13:53:21 GMT

Hi Kannuri,

for vertical reference lines you need a continous x axis. So you better should use dates instead of month. Please look at this training video for explanation:

Qlikview Vertical Reference Lines by RFB 147 - YouTube

Hope this helps

Burkhard

Re: Re: Reference line in the chart

jagannalla — Tue, 18 Mar 2014 13:59:47 GMT

Plz check the attached file. You need to add reference line for each dimensions value. It is not full solution, I'm giving just idea.

Hope you will get better solution from others.

Re: Reference line in the chart

veidlburkhard — Tue, 18 Mar 2014 14:54:36 GMT

Hi Kannuri,

a very simple solution to your problem could be to ad a second expression event with vertical labels. This would look like below:

This is the easy way...

Regards

Burkhard

Re: Re: Reference line in the chart

Wed, 19 Mar 2014 06:37:22 GMT

Hi Burkhard,

if i am using dates it is showing like this PFA

Re: Reference line in the chart

Wed, 19 Mar 2014 07:08:33 GMT

Hi jagan,

Thanks for your response but here the month no dimension is showing some invalid values??

may i know why it is showing like that?? (we have monthno as only 1,2 )

Re: Reference line in the chart

veidlburkhard — Wed, 19 Mar 2014 08:29:49 GMT

Hi Kannuri,

this is only cause your date format in the expression for the reference line was slightly incorrect. You have to use

Date#('01-06-2014', 'DD-MM-YYYY') then everything looks fine:

Enjoy

Burkhard

Re: Reference line in the chart

Wed, 19 Mar 2014 09:16:05 GMT

HI Burkhard,

Thanks for your response,but what i am trying to ask is in my date dimension i don't have

15-01-2014,

15-02-2014,....... why these are showing,any ideas???

Re: Reference line in the chart

veidlburkhard — Wed, 19 Mar 2014 09:28:32 GMT

Hi Kannuri,

we probably have different country settings, so there is a misunderstanding of the systems.

You have to look if the date format you enter into the reference line expression is the same as on your x axis in the chart. You can test this by copying it into a text box and see what is displayed there...

Hope this helps

Burkhard

Re: Re: Reference line in the chart

Wed, 19 Mar 2014 09:40:14 GMT

Hi Burkhard,

See the attached, Here i have date fields,01-01-2014,01-02-2014,01-03-2014........01-08-2014

but in chart it is not displaying 01-02-2014,01-04-2014,01-06-2014,01-08-2104 these dates

Re: Reference line in the chart

veidlburkhard — Wed, 19 Mar 2014 09:47:47 GMT

When I open your attachment I see this and it looks good:

Congratulation! Looks good.

Burkhard

Re: Reference line in the chart

Wed, 19 Mar 2014 09:55:11 GMT

hey i am asking why my date dimension is not showing all fields in the chart??

Re: Reference line in the chart

veidlburkhard — Wed, 19 Mar 2014 10:11:55 GMT

Hi Kannuri,

this is a scaling problem only. If you enlarge your chart to double or triple length you will see all the dates. Or if you use the inclined representation on the axis...

Everything is there, Kannuri, nothing is lost.

Burkhard

Re: Reference line in the chart

Wed, 19 Mar 2014 10:20:03 GMT

HI Burkhard,

Thanks a lot for your quick response and reply ..still i have a query ..why the date dimension is showing

15-01-2014,15-02-2014........like this, these fields are not there in the DATE

Re: Reference line in the chart

veidlburkhard — Wed, 19 Mar 2014 10:30:34 GMT

Hi Kannuri,

this is because you tell QV to do so. See your script:

Re: Reference line in the chart

Thu, 20 Mar 2014 05:49:55 GMT

HI Burkhard,

Is there any possibility for me to show my x-axis in string like jan 2014(mm-yyyy) ??

Re: Reference line in the chart

preminqlik — Thu, 20 Mar 2014 06:32:01 GMT

Yes you can , take the calculated dimension as follows

Month&'-'&Year

you can also do ni backend

Month&'-'&Year as MonthYear