https://community.qlik.com/t5/App-Development/Measure-from-dimension/m-p/1807051#M65672 <P>Hi Guys!</P><P>I have problem with convert dimension to measure.&nbsp;</P><P>My dimension is:</P><P>=if(<BR />sum({&lt;[MonthYear],Date={"&gt;=$(=MonthStart(AddMonths(Max(Date),-3)))&lt;=$(=MonthEnd(AddMonths(Max(Date),-1)))"}&gt;} [Sales])=0<BR />and<BR />sum({$&lt;[MonthYear],[Year]={"$(=Year(Max(Date)))"},[Month]={"$(=Month(Max(Date)))"} &gt;}[Sales])&gt;0<BR />and<BR />[RegistrationDate]&lt;monthstart(addmonths(max(Date),-3))<BR />,1,0)</P><P>This is a flag showing a customer reactivated after 3 months of no sales.</P><P>I would like to SUM how many clients have I reactivated per month in simple table:</P><P>MonthYear || Number of reactivated clients</P><P>Please help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 11 May 2021 15:56:50 GMT PapaJapa 2021-05-11T15:56:50Z https://community.qlik.com/t5/App-Development/Measure-from-dimension/m-p/1807051#M65672 <P>Hi Guys!</P><P>I have problem with convert dimension to measure.&nbsp;</P><P>My dimension is:</P><P>=if(<BR />sum({&lt;[MonthYear],Date={"&gt;=$(=MonthStart(AddMonths(Max(Date),-3)))&lt;=$(=MonthEnd(AddMonths(Max(Date),-1)))"}&gt;} [Sales])=0<BR />and<BR />sum({$&lt;[MonthYear],[Year]={"$(=Year(Max(Date)))"},[Month]={"$(=Month(Max(Date)))"} &gt;}[Sales])&gt;0<BR />and<BR />[RegistrationDate]&lt;monthstart(addmonths(max(Date),-3))<BR />,1,0)</P><P>This is a flag showing a customer reactivated after 3 months of no sales.</P><P>I would like to SUM how many clients have I reactivated per month in simple table:</P><P>MonthYear || Number of reactivated clients</P><P>Please help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 11 May 2021 15:56:50 GMT https://community.qlik.com/t5/App-Development/Measure-from-dimension/m-p/1807051#M65672 PapaJapa 2021-05-11T15:56:50Z