topic Re: Balance Sheet Help! in QlikView

Balance Sheet Help!

Fri, 22 Jun 2012 10:58:22 GMT

Hi all,

I have a formula which grabs all the previous years entries, in order to develop a balance sheet. The formula is as follows:

=if([Account Type]='Balance Sheet',sum({1<Year={$(vMaxYear)},Date={'<=$(vMaxDate)'},Month=>}(Amount)))

The Formula grabs everything as at today. However, what I want is to grab the entries up to the month/year that the user selects.

How would I go about this?

Many thanks,

jjfabian — Mon, 25 Jun 2012 08:07:55 GMT

Hi there,

your set analysis part should contain something like the following:

(the example provided will work if you have a "Year" and a "Month" select field, in which your user makes his/her selections in):

{$<Year= {$(=max(Year))}, Month= {"<=$(=max({<Year={$(=max(Year))}>} Month))"}

Regards,

Jakob

raghavsurya — Wed, 04 Jul 2012 08:17:22 GMT

Try this ...

if([Account Type]='Balance Sheet',sum({<Year={$(vMaxYear)},Date={'<=$(vMaxDate)'},Month=>}(Amount)))

Regards,

Raghav