topic Help in QlikView https://community.qlik.com/t5/QlikView/Help/m-p/496494#M1147689 <HTML><HEAD></HEAD><BODY><P>Hello, I have a bar graph that show different days when accounts fall into arrears e.g. Current, 30 Days, 60 days and so forth and at the moment i am using the following code to determine how many accounts fall into those specific catergories and it is date driven</P><P></P><P>sum<SPAN style="font-size: 8pt;">( {$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[ARREAR GROUP]</SPAN><SPAN style="font-size: 8pt;">={'30 DPD'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">[ERLM LOAN BOOK BAL]</SPAN><SPAN style="font-size: 8pt;"> ) </SPAN></P><P></P><P> so if you click on the first of the month it brings up a certain total and if i click on the 2nd of the month it just adds on to the 1st total which is fine however i would like to know if it is possible that i can only get the value and count for the specified date without it taking into account the previous day?</P></BODY></HTML> Thu, 15 Aug 2013 10:32:51 GMT 2013-08-15T10:32:51Z Help https://community.qlik.com/t5/QlikView/Help/m-p/496494#M1147689 <HTML><HEAD></HEAD><BODY><P>Hello, I have a bar graph that show different days when accounts fall into arrears e.g. Current, 30 Days, 60 days and so forth and at the moment i am using the following code to determine how many accounts fall into those specific catergories and it is date driven</P><P></P><P>sum<SPAN style="font-size: 8pt;">( {$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[ARREAR GROUP]</SPAN><SPAN style="font-size: 8pt;">={'30 DPD'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">[ERLM LOAN BOOK BAL]</SPAN><SPAN style="font-size: 8pt;"> ) </SPAN></P><P></P><P> so if you click on the first of the month it brings up a certain total and if i click on the 2nd of the month it just adds on to the 1st total which is fine however i would like to know if it is possible that i can only get the value and count for the specified date without it taking into account the previous day?</P></BODY></HTML> Thu, 15 Aug 2013 10:32:51 GMT https://community.qlik.com/t5/QlikView/Help/m-p/496494#M1147689 2013-08-15T10:32:51Z