topic Re: How to click on specific date in QlikView https://community.qlik.com/t5/QlikView/How-to-click-on-specific-date/m-p/852060#M298766 <HTML><HEAD></HEAD><BODY><P>Not sure if I've fully understood.</P><P></P><P>Maybe like</P><P>=SUM({&lt;Date = {"&lt;=$(=max(Date))"}&gt;} Balance)</P><P></P><P>or </P><P>=if(len(trim(Balance)), <SPAN style="font-size: 13.3333330154419px;">SUM({&lt;Date = {"&lt;=$(=max(Date))"}&gt;} Balance), only(Balance) )</SPAN></P></BODY></HTML> Thu, 18 Jun 2015 13:19:25 GMT swuehl 2015-06-18T13:19:25Z How to click on specific date https://community.qlik.com/t5/QlikView/How-to-click-on-specific-date/m-p/852059#M298765 <HTML><HEAD></HEAD><BODY><P>Dear all</P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Date</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Balance</TH></TR><TR><TD style="padding: 2px;">01-01-2015</TD><TD style="padding: 2px;">1000</TD></TR><TR><TD style="padding: 2px;">15-01-2015</TD><TD style="padding: 2px;">2000</TD></TR><TR><TD style="padding: 2px;">25-1-2015</TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P>suppose i have 2 dates 01-01-2015 and 15-01-2015 <SPAN style="font-size: 10pt; line-height: 1.5em;">when i click the date field of specific date it show me that date balance but my requirement is when i click on 25-01-2015&nbsp; the balance is not present&nbsp; it show me the balance of 01 and 15 date.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">if(date&lt;=date selected,balance)<BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"> </SPAN></P></BODY></HTML> Thu, 18 Jun 2015 13:14:59 GMT https://community.qlik.com/t5/QlikView/How-to-click-on-specific-date/m-p/852059#M298765 2015-06-18T13:14:59Z Re: How to click on specific date https://community.qlik.com/t5/QlikView/How-to-click-on-specific-date/m-p/852060#M298766 <HTML><HEAD></HEAD><BODY><P>Not sure if I've fully understood.</P><P></P><P>Maybe like</P><P>=SUM({&lt;Date = {"&lt;=$(=max(Date))"}&gt;} Balance)</P><P></P><P>or </P><P>=if(len(trim(Balance)), <SPAN style="font-size: 13.3333330154419px;">SUM({&lt;Date = {"&lt;=$(=max(Date))"}&gt;} Balance), only(Balance) )</SPAN></P></BODY></HTML> Thu, 18 Jun 2015 13:19:25 GMT https://community.qlik.com/t5/QlikView/How-to-click-on-specific-date/m-p/852060#M298766 swuehl 2015-06-18T13:19:25Z