topic Value can't reflect by accumulate day in day. in App Development https://community.qlik.com/t5/App-Development/Value-can-t-reflect-by-accumulate-day-in-day/m-p/37636#M2564 <HTML><HEAD></HEAD><BODY><P>Dear My Friends</P><P>Can someone help to move forward my big big gap of knowledge to do something great. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P>I am&nbsp; working with two data sheet where there has 2 DATE filed in different . I mean one is current record and another is tracker from 3 year ago. Here I am trying to get accumulate count from Tracker to reflect current record date. But it isn't showing correct number showing in Trend Line. Please have a look below example and give me your kindly advise.</P><P></P><P>I trying as ( count({$&lt;Tracker Date={"&lt;=$(=Date(max(record date)))"} &gt;} [Tracker Date]) ) .. But it can't work. and showing Maximum number only.</P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196546_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 16 Mar 2018 03:31:36 GMT thawdewai 2018-03-16T03:31:36Z Value can't reflect by accumulate day in day. https://community.qlik.com/t5/App-Development/Value-can-t-reflect-by-accumulate-day-in-day/m-p/37636#M2564 <HTML><HEAD></HEAD><BODY><P>Dear My Friends</P><P>Can someone help to move forward my big big gap of knowledge to do something great. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P>I am&nbsp; working with two data sheet where there has 2 DATE filed in different . I mean one is current record and another is tracker from 3 year ago. Here I am trying to get accumulate count from Tracker to reflect current record date. But it isn't showing correct number showing in Trend Line. Please have a look below example and give me your kindly advise.</P><P></P><P>I trying as ( count({$&lt;Tracker Date={"&lt;=$(=Date(max(record date)))"} &gt;} [Tracker Date]) ) .. But it can't work. and showing Maximum number only.</P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/196546_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Fri, 16 Mar 2018 03:31:36 GMT https://community.qlik.com/t5/App-Development/Value-can-t-reflect-by-accumulate-day-in-day/m-p/37636#M2564 thawdewai 2018-03-16T03:31:36Z