Growth value not coming properly - Qlik Community

prma7799 · ‎2015-12-24

Hi All,

As compare to last year month data my grwoth values not coming properly.

and in my chart i am also not getting bar for nov-14 .

PFA.

Anonymous · ‎2015-12-24

What issue you are facing?

For growth, you are taking this expression: Current Year Sales - PY Sales / PY Sales

which is giving you right figure..

Anonymous · ‎2015-12-24

Also attached a new sample file...

It is opening like a image not a qvw

tresesco · ‎2015-12-24

I suggest, not to delete replies. Discussion helps others to help you or people who might face similar problem in future. People might have questions in mind whice might had been discussed in the thread earlier - now might have to reply to answer them again. Coming to your prob sol.

Noc-2014 was not coming because , this period had no data for 30th. Ideally you might wwant to just check for the latest month - if all dates are available in the transaction. If, so try:

=aggr(if(not(MonthName=Max(total MonthName) and Day(max([Posting Date]))<>Day(MonthEnd(max([Posting Date])))),MonthYear), MonthYear)

And you say - 'grwoth values not coming properly.'. You leave us thinking thousnads of improper values, which is not helpful. Try to expand your 'not proper' term.