https://community.qlik.com/t5/App-Development/How-to-calculate-in-Table-straight-table/m-p/1610313#M45343 <P>Hello!</P><P>One (may be stipud) question.</P><P>I calculate unique users rolling one year (last 365 days).</P><P>This expression:&nbsp;Count({&lt;MyMonth={"&gt;=$(=max(MyMonth)-365)&lt;=$(=max(MyMonth))"}&gt;}DISTINCT UserID).</P><P>This expression good works in KPI object, when I use MyMonth filter.</P><P>I need create straight table: rows (dimension) - MyMonth, one column - unique "last-365" users. But when I use this expression on measure, it calculates wrong (calculates users only 1 month).</P><P>Where is my stupid mistake?</P> Sat, 16 Nov 2024 05:02:49 GMT Evgen_Belov 2024-11-16T05:02:49Z https://community.qlik.com/t5/App-Development/How-to-calculate-in-Table-straight-table/m-p/1610313#M45343 <P>Hello!</P><P>One (may be stipud) question.</P><P>I calculate unique users rolling one year (last 365 days).</P><P>This expression:&nbsp;Count({&lt;MyMonth={"&gt;=$(=max(MyMonth)-365)&lt;=$(=max(MyMonth))"}&gt;}DISTINCT UserID).</P><P>This expression good works in KPI object, when I use MyMonth filter.</P><P>I need create straight table: rows (dimension) - MyMonth, one column - unique "last-365" users. But when I use this expression on measure, it calculates wrong (calculates users only 1 month).</P><P>Where is my stupid mistake?</P> Sat, 16 Nov 2024 05:02:49 GMT https://community.qlik.com/t5/App-Development/How-to-calculate-in-Table-straight-table/m-p/1610313#M45343 Evgen_Belov 2024-11-16T05:02:49Z