topic Re: data not coming properly for two axis chart in QlikView

data not coming properly for two axis chart

Wed, 28 Oct 2015 10:56:38 GMT

Dear All,

I want to implement current year data in bar chart with growth formula when am doing this the data is not coming properly....

PFA...

Thanks

settu_periasamy — Thu, 29 Oct 2015 03:30:12 GMT

Hi prashant,

May be try the below expression.

=(fabs(SUM(Values/10000000) / above(sum(Values/10000000)) -1))*100

Thu, 29 Oct 2015 03:40:13 GMT

Hi Settu,

When i used above expression values is not coming for all first Quarter.

settu_periasamy — Thu, 29 Oct 2015 16:17:26 GMT

Hi,

How do we know the growth in first quarter?

May be you can use same data for quarter 1..like

=if (rowno ()=0,sum (Values/10000000),

(fabs(SUM(Values/10000000) / above(sum(Values/10000000)) -1))*100))