Set Analysis to Calculate YTD Expenses

jcampbell — Thu, 17 Nov 2011 13:51:42 GMT

I thought I would share a simple calculation I created in a document I'm working in:

I have a document loading various elements of data including an expense amount. I wanted to create a small statistic box in the opening screen with YTD expenses without the user needing to select the Category "Expense", etc. So here is the calculation I used:

SUM({$<Year = {$(=max(Year))}, Category = {'Expense'}>} [Expense Amount])

I hope you find this useful.

Josh

topic Set Analysis to Calculate YTD Expenses in QlikView

Set Analysis to Calculate YTD Expenses