Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

data not coming properly for two axis chart

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

3 Replies

Re: data not coming properly for two axis chart

Hi prashant,

May be try the below expression.

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

Not applicable

Re: data not coming properly for two axis chart

Hi Settu,

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

ss.png

Re: data not coming properly for two axis chart

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))

Community Browser