topic Calculating Budget Value.. in QlikView

Calculating Budget Value..

Wed, 08 Oct 2014 15:54:40 GMT

Hi all,

I have six month total values of budget and i am spend some amount value into budget value for every month how to deduct spending value for every month(minus value into every month values), For Exmaple July month i have 1000 here i am spend 100 july month itself, now aug month values 900,again i am spend 75 now sep value 825 like..please help asap.

Regards,

K.S.

Re: Calculating Budget Value..

Wed, 08 Oct 2014 15:55:56 GMT

Hi All,

like ,Cumalative value minus every month spend value.

Regards,

K.S.

Re: Calculating Budget Value..

Wed, 08 Oct 2014 16:08:10 GMT

Hi,

Please help me ASAP now.little critical.

Regards,

Senthil.K

Re: Calculating Budget Value..

antoniotiman — Wed, 08 Oct 2014 16:10:03 GMT

Hi,

maybe like this.

See Attachment.

Regrds

Re: Calculating Budget Value..

Wed, 08 Oct 2014 16:16:32 GMT

Hi Antonio,

Thanks for your support.

Our company, as per policy not allow to open other QVW documnets.please send me the script.

Regards,

K.S.

Re: Re: Calculating Budget Value..

antoniotiman — Wed, 08 Oct 2014 16:28:50 GMT

I try.

Create variable vBudget = 1000

Dimension Month

Expressions in Pivot Table

1) Sum(Value)

2) If(Dimensionality() =0,vBudget,

vBudget-RangeSum(Top(Sum(Value),1,RowNo()))

Check TOTAL in Dimension Month