topic Re: Expression? in QlikView

Expression?

khadeer — Tue, 29 Jan 2013 11:11:51 GMT

Hi Friends,

I have Opening balance for every year, field name is OpeningBalance

and amount value of that every month, Suppose my opening balance is 5000

my amount respective months is Apr= 200, May= -100, Jun=100, Here field name is Amount.

Now if i selected Apr month it will show as 5200( OpeningBalance+Amount)

if i selected May 5100, Previous month value- present month(5200-100)

i am getting cumulative in respective amount field by writing

sum({<Month={$(=max(Month))>}Amount), but i want to show cumilative including that opningbalance.

Re: Expression?

perumal_41 — Tue, 29 Jan 2013 11:33:49 GMT

Hi,

Please Upload Sample Application for Reference

Re: Expression?

Tue, 29 Jan 2013 12:00:02 GMT

Have you tried the following expression, omitting the month selection for OpeningBalance?

sum({<Month={$(=max(Month))>}Amount) + sum({<Month=>}OpeningBalance)

Re: Expression?

khadeer — Tue, 29 Jan 2013 12:23:52 GMT

I tried that but its not working.

My problem is i am getting correct value for individual months, when i am taking 2 r more months suppose Apr+May, its taking addition of both, but i want may only, if selected Q1 ... it has to show june end value.... if my selection is Q+Q2 ... i want to show sept value only

Re: Expression?

perumal_41 — Tue, 29 Jan 2013 12:27:50 GMT

Hi,

Try this one

Rangesum({<Month={$(=max(Month))>}Amount) + sum({<Month=>}OpeningBalance).if is not working this expression .please upload sample Appliation