topic Re: Outstanding issue? in QlikView

Outstanding issue?

Anonymous — Wed, 08 Oct 2014 13:21:27 GMT

Hi,

I wanted to show the selected date outstanding amount to last 12 months .

suppose i have the outstanding amount in jan = 200 and mar = 300

so outstanding amount as on April month is 500.and i made payment in may = 500,

so may month outstanding is 0,and outstanding of june = 400 and july =300 then in chart it has to display like this

outstanding of as on apr = 500 as on may =0 as on june = 400 and as on july =700 it has to sum with previous month.

please give me ideas its urgent requirement.

Thanks,

krishna

Re: Outstanding issue?

JonnyPoole — Wed, 08 Oct 2014 13:26:01 GMT

You can use the accumulation function to aggregate prior records (months), or use the above() or before() functions with a rangesum() to have more control over how many previous rows you accumulate for the current row.

precise answer would depend on your data structure. a QVW will supply more a definitive solution

Re: Outstanding issue?

Anonymous — Wed, 08 Oct 2014 13:33:00 GMT

i did that thing but its showing in chart jan =200 ,mar= 300,apr=0 ,may =0 ,jun = 400 and july = 300 but i need to show the as on apr =500,may =0,jun = 400 and july =700

Re: Outstanding issue?

JonnyPoole — Wed, 08 Oct 2014 13:36:00 GMT

I'm not sure i would need to work with an example. sorry.