topic Re: opening sum in QlikView

opening sum

sakamsureshbabu — Tue, 31 Mar 2015 04:46:56 GMT

Hi All

in my requirement i required opening balance.That menace i want to calculate no.of personae are joined from starting of the scheme to before date of my selected Start date.

i am using below equation

=count(DISTINCT if((InvestDate>=Start and InvestDate<=End), MasterKey))

where Start is selected Start date

End is selected End date

Re: opening sum

Agis-Kalogiannis — Tue, 31 Mar 2015 19:42:20 GMT

You can do something like this:

=count({$<InvestDate={'>=$(StartDate)<=$(EndDate)'}>}DISTINCT MasterKey)

And you can create two variables, StartDate and EndDate, and two Calendar objects that will modify the variable values.

Thanks

Agis

Re: opening sum

sakamsureshbabu — Wed, 01 Apr 2015 11:58:42 GMT

Thanks Agis.

Re: opening sum

Agis-Kalogiannis — Wed, 01 Apr 2015 12:30:40 GMT

Hi Suresh

Could you please mark the answer as helpful or correct if this is what you are looking for?

Thanks

Agis