Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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))