topic Re: Line Chart value changes on selection in QlikView

Line Chart value changes on selection

Thu, 26 Nov 2015 10:17:42 GMT

Hi Experts,

I have created a line chart with month as dimension and used aggr() function in expression.

The line chart is giving the correct value but it changes on selection of month and showing wrong value.

Regards,

Anjali Gupta

Mark_Little — Thu, 26 Nov 2015 10:20:13 GMT

Hi,

Is it possible to supply some more information or a sample Qvw?

What is the expression?

What are you seeing?

What are you expecting to see?

Mark

Thu, 26 Nov 2015 10:22:50 GMT

Hi Anjali ,

can u share what wrong values your are getting detail

Thu, 26 Nov 2015 10:54:42 GMT

Hi Mark,

Before any selection the line chart has the value :

May : 100.00%

Sep : 99.95%

Oct : 99.97%

whereas on selecting the month as Sep the value of Sep changes from 99.95% to 99.97%

Below is the image:

Expression Used:

=Avg(Aggr(

Num( 1-(Num(sum(field1))

/(Interval(MonthEnd( [Year-Month]))-MonthStart(min([Year-Month])),'mm'))),'##.###%'))

,Field2))

Due to some restriction I can't share the field1's and field2's exact name.