topic Re: Aggr in Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Aggr-in-Calculated-Dimension/m-p/88061#M760413 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG><SPAN style="color: #ff0000;">Aggr(</SPAN>If(Count({&lt;SC_Time_Dim = {'M'}, SC_Date_Month = {'$(=Month(MonthStart(Num(Today()-1))-1))'}, SC_Date_Year =&nbsp; {'$(=Year(MonthStart(Num(Today()-1))-1))'}&gt;} SC_Metric_KEY) &gt; 0, SC_Stream)<SPAN style="color: #ff0000;">, SC_Stream)</SPAN></STRONG></P></BODY></HTML> Wed, 15 Aug 2018 15:07:49 GMT sunny_talwar 2018-08-15T15:07:49Z Aggr in Calculated Dimension https://community.qlik.com/t5/QlikView/Aggr-in-Calculated-Dimension/m-p/88060#M760412 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>Can someone help me fix this script? I'm encountering an error when i create a calculated dimension in my straight table:</P><P></P><P>=if(count({&lt;SC_Time_Dim={'M'}, SC_Date_Month= {'$(=Month(MonthStart(num(today()-1))-1))'}, SC_Date_Year= {'$(=Year(MonthStart(num(today()-1))-1))'}&gt;} SC_Metric_KEY)&gt; 0,SC_Stream)</P><P></P><P>Thanks for the help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggr-in-Calculated-Dimension/m-p/88060#M760412 Anonymous 2020-11-25T16:16:04Z Re: Aggr in Calculated Dimension https://community.qlik.com/t5/QlikView/Aggr-in-Calculated-Dimension/m-p/88061#M760413 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG><SPAN style="color: #ff0000;">Aggr(</SPAN>If(Count({&lt;SC_Time_Dim = {'M'}, SC_Date_Month = {'$(=Month(MonthStart(Num(Today()-1))-1))'}, SC_Date_Year =&nbsp; {'$(=Year(MonthStart(Num(Today()-1))-1))'}&gt;} SC_Metric_KEY) &gt; 0, SC_Stream)<SPAN style="color: #ff0000;">, SC_Stream)</SPAN></STRONG></P></BODY></HTML> Wed, 15 Aug 2018 15:07:49 GMT https://community.qlik.com/t5/QlikView/Aggr-in-Calculated-Dimension/m-p/88061#M760413 sunny_talwar 2018-08-15T15:07:49Z