topic Set Analysis and Aggr in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-and-Aggr/m-p/227640#M79744 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have an expression that I use to calculate the max value of a balance from the last inputted value over a period of time that works perfectly...</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />firstsortedvalue(DISTINCT aggr(min({&lt;[BOM Chart - Date] = {"&lt;=$(=date(only(today())+91))&gt;=$(=date(only(today())-91))"}&gt;} [BOM Chart - Balance]),[BOM Chart - Timescale],[BOM Chart - AutoNo]),-[BOM Chart - AutoNo])<BR /></PRE><BR /><BR /> <P>However, what I need to add to this is to do this calculation for each site, i.e. Site A through to Site F. I was thinking of doing something like this:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />(firstsortedvalue(DISTINCT aggr(min({&lt;[BOM Chart - Site] = {'Site'},[BOM Chart - Date] = {"&lt;=$(=date(only(today())+91))&gt;=$(=date(only(today())-91))"}&gt;} [BOM Chart - Balance]),[BOM Chart - Timescale],[BOM Chart - AutoNo]),-[BOM Chart - AutoNo])) +<BR />(firstsortedvalue(DISTINCT aggr(min({&lt;[BOM Chart - Site] = {'Site2'},[BOM Chart - Date] = {"&lt;=$(=date(only(today())+91))&gt;=$(=date(only(today())-91))"}&gt;} [BOM Chart - Balance]),[BOM Chart - Timescale],[BOM Chart - AutoNo]),-[BOM Chart - AutoNo]))<BR /></PRE><BR /><BR /> <P>But this doesn't work, infact, only specifying one site doesnt work.. After looking on the forums, I saw that someone had a similiar issue where Aggr and set analysis doesnt work.</P><P>If anyone has any other ideas on how I can perform this calculation for multiple sites, it would be appreciated!!!</P><P>Kind Regards,<BR />Dayna Litherland</P></BODY></HTML> Mon, 01 Feb 2010 11:08:27 GMT Dayna 2010-02-01T11:08:27Z Set Analysis and Aggr https://community.qlik.com/t5/QlikView/Set-Analysis-and-Aggr/m-p/227640#M79744 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have an expression that I use to calculate the max value of a balance from the last inputted value over a period of time that works perfectly...</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />firstsortedvalue(DISTINCT aggr(min({&lt;[BOM Chart - Date] = {"&lt;=$(=date(only(today())+91))&gt;=$(=date(only(today())-91))"}&gt;} [BOM Chart - Balance]),[BOM Chart - Timescale],[BOM Chart - AutoNo]),-[BOM Chart - AutoNo])<BR /></PRE><BR /><BR /> <P>However, what I need to add to this is to do this calculation for each site, i.e. Site A through to Site F. I was thinking of doing something like this:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />(firstsortedvalue(DISTINCT aggr(min({&lt;[BOM Chart - Site] = {'Site'},[BOM Chart - Date] = {"&lt;=$(=date(only(today())+91))&gt;=$(=date(only(today())-91))"}&gt;} [BOM Chart - Balance]),[BOM Chart - Timescale],[BOM Chart - AutoNo]),-[BOM Chart - AutoNo])) +<BR />(firstsortedvalue(DISTINCT aggr(min({&lt;[BOM Chart - Site] = {'Site2'},[BOM Chart - Date] = {"&lt;=$(=date(only(today())+91))&gt;=$(=date(only(today())-91))"}&gt;} [BOM Chart - Balance]),[BOM Chart - Timescale],[BOM Chart - AutoNo]),-[BOM Chart - AutoNo]))<BR /></PRE><BR /><BR /> <P>But this doesn't work, infact, only specifying one site doesnt work.. After looking on the forums, I saw that someone had a similiar issue where Aggr and set analysis doesnt work.</P><P>If anyone has any other ideas on how I can perform this calculation for multiple sites, it would be appreciated!!!</P><P>Kind Regards,<BR />Dayna Litherland</P></BODY></HTML> Mon, 01 Feb 2010 11:08:27 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-and-Aggr/m-p/227640#M79744 Dayna 2010-02-01T11:08:27Z