Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
settu_periasamy
Master III
Master III

Hi prashant,

May be try the below expression.

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

Not applicable
Author

Hi Settu,

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

ss.png

settu_periasamy
Master III
Master III

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