topic aggregated dimension and set analysis in QlikView https://community.qlik.com/t5/QlikView/aggregated-dimension-and-set-analysis/m-p/200315#M58890 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I speek only a little english, so I try to explain my problem.</P><P>I have daily NAV in a fund application.</P><P>My pivot's dimensions are FUND_ID and MonthName(NAV_DATA), I want to calculate an customized average :</P><P>NAV(lastdayinmonth)-NAV(firstdayinmonth)/365</P><P>I used set analysis</P><P>(SUM({&lt;NAV_DATA={'$(=date(MAX(NAV_DATA)))'}&gt;} NAV)-SUM({&lt;NAV_DATA={'$(=date(MIN(NAV_DATA)))'}&gt;} NAV))/365, however MAX and MIN are calulated on ALL CURRENT SELECTION DATES, but I whish they were calculated on all DATES included in CURRENT DIMENSION value (pivot's row) .</P><P></P><P>can anyone help me?</P><P>Thanks</P></BODY></HTML> Tue, 14 Sep 2010 15:30:06 GMT 2010-09-14T15:30:06Z aggregated dimension and set analysis https://community.qlik.com/t5/QlikView/aggregated-dimension-and-set-analysis/m-p/200315#M58890 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I speek only a little english, so I try to explain my problem.</P><P>I have daily NAV in a fund application.</P><P>My pivot's dimensions are FUND_ID and MonthName(NAV_DATA), I want to calculate an customized average :</P><P>NAV(lastdayinmonth)-NAV(firstdayinmonth)/365</P><P>I used set analysis</P><P>(SUM({&lt;NAV_DATA={'$(=date(MAX(NAV_DATA)))'}&gt;} NAV)-SUM({&lt;NAV_DATA={'$(=date(MIN(NAV_DATA)))'}&gt;} NAV))/365, however MAX and MIN are calulated on ALL CURRENT SELECTION DATES, but I whish they were calculated on all DATES included in CURRENT DIMENSION value (pivot's row) .</P><P></P><P>can anyone help me?</P><P>Thanks</P></BODY></HTML> Tue, 14 Sep 2010 15:30:06 GMT https://community.qlik.com/t5/QlikView/aggregated-dimension-and-set-analysis/m-p/200315#M58890 2010-09-14T15:30:06Z