topic Min and Max Line in Line Chart w/ Grouped Dimension in QlikView

Min and Max Line in Line Chart w/ Grouped Dimension

Anonymous — Fri, 07 Jun 2013 15:12:09 GMT

I have a line chart showing the distinct count of incidents opened over a span of the last 3 full months and month to date. I am attempting to add two reference lines or expression lines that show the highest and lowest value in the chart.

Dimension Group: Date/Time for Month, WeekStart, Day, Hour

Expression: Count(DISTINCT Ticket_Number)

Re: Min and Max Line in Line Chart w/ Grouped Dimension

Fri, 07 Jun 2013 21:26:43 GMT

Hi,

in the properties of the chart U have a tab namned Presentation. Down to the right U will find something like Reference line. The U write a suitable formula like Max(..) depending on yuor data u might need to do some more calculations in your formula.

Brg

//KArathorn