topic Set analysis sum field between calculated years in QlikView

Set analysis sum field between calculated years

timmy — Sun, 27 Jun 2010 06:50:14 GMT

Hey,

I have the following formula:

sum( {1<Boekingsdatum = {">39941<40178"}>} [Prorata inkomsten] )

how can i change the 39941 with a calculated number; for example max(Date)?

Regards

Timmy

Or — Sun, 27 Jun 2010 09:53:05 GMT

You can use formulas in your set expressions using dollar-sign expansion. The following example is from the QV documentation:

sum( {$<Year = {$(#=Only(Year)-1)}>} Sales )

returns the sales for the previous year in relation to current selection. Here, a dollar-sign expansion is used to calculate previous year.