topic Re: Max value line in QlikView

Max value line

Mon, 04 Aug 2014 12:47:05 GMT

Hi all,

I got a bar chart that contains 2 expressions. Showing me the revenue over week 1 - 30

Now I would like to add a line/reference that marks the point of the max revenue. This line should move troughout the whole chart.

I Could easily just put in 740 in an expression but I then I need to adjust this when we make a revenue of 750.

This is what I got:

IF(Rank(SUM( Revenue)= 1, SUM(Revenue))/1000 = Gives me max revenue and marks it but does not create a line.

kind regards

Vincent

Re: Max value line

joshabbott — Mon, 04 Aug 2014 12:53:21 GMT

Are you putting this in the 'Reference Lines' or as a new expression?

This seems like something you'd want in the reference lines.

Re: Max value line

Mon, 04 Aug 2014 12:55:36 GMT

i tried putting this in the reference line 1 min ago.

Problem is It does not aggregate the total revenue but the revenue per salesman

Re: Max value line

joshabbott — Mon, 04 Aug 2014 13:09:01 GMT

Well, then could it be another expression represented by a line? You may need to take the 'if' piece out, because the rank would only be 1 one time, and would probably be only represented by a dot in your chart. Could you post the qvw or a sample of the qvw you are working on?

Re: Max value line

jonathandienst — Mon, 04 Aug 2014 13:20:38 GMT

This is the expression to get the maximum amount per salesman (and assumes that Salesman is the only dimension on the chart):

=Max(Aggr(SUM(Revenue))/1000, Salesman))

Use this expression for the reference line.

HTH

Jonathan

Re: Max value line

Mon, 04 Aug 2014 13:26:17 GMT

Thanks!