topic Set analysis.....again!! in QlikView

Set analysis.....again!!

samvile18 — Thu, 18 Aug 2011 14:07:39 GMT

Hello everyone,

Hoping this will be a quickie for one of you clever clogs out there. I have the following syntax which calculates my Full Year budget, I need to amend it so it shows a YTD budget....does anyone know how I can do this?

Sum({$<Year = {2011},Measure={'Budget'}>}Value)/1000

Any help is greatly appreciated.

Set analysis.....again!!

swuehl — Thu, 18 Aug 2011 14:14:44 GMT

I assume you have also a Date field:

You need to limit your set expression also to the Date field:

=Sum({$<Year = {2011},Measure={'Budget'}, Date={"<=$(=today())"}>}Value)/1000

Regarding Point in Time reporting, I have found that article quite interesting:

http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/

regards,

Stefan

Set analysis.....again!!

lironbaram — Thu, 18 Aug 2011 14:15:06 GMT

hei

assuming you have a date filed

then

Sum({$<Year = ,Month=,Qtr=,Day=, Date={">=$(=YearStart(Today())) <=$(=date(today()))"},Measure={'Budget'}>}Value)/1000

so what it does is diregarding selections in the time fields and putting the constreins on the date field