topic Re: Growth value not coming properly in QlikView

Growth value not coming properly

prma7799 — Thu, 24 Dec 2015 05:15:58 GMT

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.

Re: Growth value not coming properly

Anonymous — Thu, 24 Dec 2015 05:30:44 GMT

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

Re: Growth value not coming properly

Anonymous — Thu, 24 Dec 2015 05:31:47 GMT

Also attached a new sample file...

It is opening like a image not a qvw

Re: Growth value not coming properly

tresB — Thu, 24 Dec 2015 07:36:29 GMT

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.