topic Re: values getting changed in QlikView

values getting changed

prma7799 — Tue, 19 Jan 2016 09:19:02 GMT

Hi All,

I have 2 expression in the attached.

PFA

My question is when I select Months my 2 expression "Growth" values changed.

Thanks

Re: values getting changed

MK_QSL — Tue, 19 Jan 2016 09:24:52 GMT

May be try this

Growth

=(( (SUM({<MONTH=>} [Gross Sales Amount]) - SUM({<MONTH=>} [Sales Return Amount]) )

-above((SUM( {<MONTH=>} [Gross Sales Amount]) - SUM( {<MONTH=>} [Sales Return Amount]) )

,12))/above((SUM( {<MONTH=>} [Gross Sales Amount]) - SUM({<MONTH=>} [Sales Return Amount]) ),12)) * 100

Re: values getting changed

sunny_talwar — Tue, 19 Jan 2016 09:40:24 GMT

And may be this to the other expression:

YTD Sale

(Sum({<Yea r=, Quarter =, Month =, FiscalYear = {">$(vFY)"}, [Posting Date] = {">=$(=QuarterStart(Min({<Month =>}[Posting Date]),4))<=$(=MonthStart(Today())))"}>} [Gross Sales Amount]) -Sum({<Year =, Quarter =, Month =, FiscalYear={">$(vFY)"},[Posting Date]={">=$(=QuarterStart(Min({<Month =>}[Posting Date]),4 ))<=$(=MonthStart(Today())))"}>} [Sales Return Amount]))/100000

Re: values getting changed

prma7799 — Tue, 19 Jan 2016 09:48:02 GMT

I tried but values are wrong

Re: values getting changed

sunny_talwar — Tue, 19 Jan 2016 09:49:27 GMT

Can you elaborate on what do you mean when you say values are wrong?

Re: values getting changed

prma7799 — Tue, 19 Jan 2016 09:57:52 GMT

Hi Sunny,

When I applied above solution then my growth values are shoving me wrong.

Thanks

Re: values getting changed

sunny_talwar — Tue, 19 Jan 2016 10:02:17 GMT

I hope you have replaced MONTH with your MonthField (Whatever its called) and then tried it? I see no reason why your expression which worked earlier won't work now. Because all Manish prescribed is to help your expression not change based on any selection made in the MonthField.

Would you be able to share a sample if you are still not able to figure it out?

Re: values getting changed

prma7799 — Tue, 19 Jan 2016 10:02:27 GMT

PFA

Re: values getting changed

MK_QSL — Tue, 19 Jan 2016 10:05:53 GMT

Where is vFY in your variable definition?

Re: values getting changed

prma7799 — Tue, 19 Jan 2016 10:15:53 GMT

vFY =Year(addyears(max(Date),-4))

Re: values getting changed

tresB — Tue, 19 Jan 2016 10:23:41 GMT

Try redefiing the variable like:

vFY =Year(addyears(max( {<MonthName>}Date),-4))

You might have to include other time dimensions too to bypass their selection effect.

Re: values getting changed

prma7799 — Tue, 19 Jan 2016 10:36:32 GMT

Hi Manish,

In expression there is no need to FiscalYear={">$(vFY)"} (vFY).

I want when i select month then growth figure is come properly

Growth formula is ((CYMonth - LYMonth) / LYMonth )*100

Thanks

Re: values getting changed

prma7799 — Wed, 20 Jan 2016 03:44:00 GMT

Hi All / tresesco, jagan , sunindia , swuehl , maxgro,

Any solution on this ?

Thanks