topic Re: Formatting graphs in QlikView

Formatting graphs

Fri, 29 Nov 2013 09:03:31 GMT

Hi again,

I have two questions regarding how to structure and format numbers in a graph. I am using a Line Chart for this.

1. The graph i have is filled with 0 values. That makes it look very "skippy" with the graph jumping up an down. Is there a way to smooth this graph out? I know there is a function under the Expression Tab to use the trend lines, but I dont think this gives a good enough representation.

2. I would like to input a line marking the 1200 point. This would be a vertical, static line at 1200 running through the graph. Any ideas?

Cheers,

Re: Formatting graphs

peschu123 — Fri, 29 Nov 2013 10:02:31 GMT

Hi Nils,

regarding your second question:

In chart properties

1. Axes Tab: You can mark the checkbox "Continuous" for the Dimension Axis.

2. Presentation Tab: Reference Lines "Add..Expression: 1200

I think u have to add a static min/max on the Axes tab.

Could you explain the first problem further... ?

Regards peter

Re: Formatting graphs

Fri, 29 Nov 2013 10:11:26 GMT

thank you peter,

1. that solved it

2. i cant get the reference line to set up for 1200 vertically. i can only get it to lay down on the x-axis. i just opened the expression and set it to:

=today()-received_date=1200

but this is not working.

Re: Formatting graphs

sundarakumar — Fri, 29 Nov 2013 10:14:05 GMT

Hi Nils,

Your app doesn't have any zero,, its just one...what i feel is your expression might need some chages...

can you explain your requirement???

-Sundar

Re: Formatting graphs

Fri, 29 Nov 2013 10:23:27 GMT

i need there to be a vertical line going through the graph at the 1200 point. just a red line marking in the graph where 1200 is.

Re: Re: Formatting graphs

sundarakumar — Fri, 29 Nov 2013 12:33:11 GMT

is your requirement something like this?

see attachment..

For this i have added a background image in colors tab with a red line...

create an image with a red line where ever you want it to be.

Hope this helps...

-Sundar

Re: Formatting graphs

rustyfishbones — Fri, 29 Nov 2013 12:46:04 GMT

Hi Nils,

this video on youtube may help

Qlikview Vertical Reference Lines by RFB 147

Also see below, On the presentation tab, add reference line with your expression, you can say =1200 for your expression

Re: Formatting graphs

Fri, 29 Nov 2013 12:49:46 GMT

hi, i cant see any youtube link?

Re: Formatting graphs

rustyfishbones — Fri, 29 Nov 2013 12:50:59 GMT

I did not send the link as sometimes it takes days to be authorised by the Community manager

if you go to youtube and type in

Qlikview Vertical Reference Lines by RFB 147

Re: Formatting graphs

Fri, 29 Nov 2013 12:51:14 GMT

sorry, but that will not do. i need it to be dynamic in the graph since i may need to scroll the graph/change the dimensions of it. then i need the line to follow along. but yes, you got the general idea

Re: Formatting graphs

Fri, 29 Nov 2013 12:53:07 GMT

haha, got it! i will watch the video now

Re: Formatting graphs

Fri, 29 Nov 2013 12:55:58 GMT

my "continues x" location box is greyed out? i am using a bar chart - may that cause issues?

Re: Formatting graphs

rustyfishbones — Fri, 29 Nov 2013 13:04:33 GMT

Hi Nils,

Try ticking the box for continuous and see if that works, it does for me, however it skews the chart

Re: Formatting graphs

peschu123 — Fri, 29 Nov 2013 13:05:01 GMT

In the first example it was available like I suggested in my first post

Re: Formatting graphs

Fri, 29 Nov 2013 13:21:40 GMT

i checked that, it skewed the chart yes, but i still didnt get it to work. are you using the same YEARSTART(TODAY()) formula as you use in your above example?

Re: Formatting graphs

rustyfishbones — Fri, 29 Nov 2013 13:27:57 GMT

No,

for the expression i said =1200

Re: Formatting graphs

Fri, 29 Nov 2013 13:30:49 GMT

that works, thank you. now why does the graph skew up like that? i dont want it stacked - rather grouped as it was...

Re: Formatting graphs

rustyfishbones — Fri, 29 Nov 2013 13:36:27 GMT

Hi Nils,

I am looking at this too, it's obviously something to do with TODAY()-received_date

I try look at it

Re: Formatting graphs

Fri, 29 Nov 2013 13:39:41 GMT

thank you. i need that type of formula however since i need the chart to be dynamically updated (since dates are going to change). the solution i though of was today()-received_date but i dont know if this is optimal?

Re: Formatting graphs

rustyfishbones — Fri, 29 Nov 2013 14:22:41 GMT

Hi Nils,

the reason for the negative number is that the received_date goes beyond today. Why would you have a received date greater than today?