topic Re: StartDate EndDate percentage calculation in QlikView https://community.qlik.com/t5/QlikView/StartDate-EndDate-percentage-calculation/m-p/807415#M1028705 <HTML><HEAD></HEAD><BODY><P>I've worked it out using the expression</P><P></P><P>=Num (1-( FirstSortedValue([Close], [Time-Date], 1)&nbsp; / FirstSortedValue([Close], -1*[Time-Date], 1) ))*100</P><P></P><P>not sure if this is a correct one, however it works for now, but not as Block Chart (won't show negative values with positive), thus I use Bar Chart temporarily.</P></BODY></HTML> Sat, 14 Feb 2015 19:13:36 GMT 2015-02-14T19:13:36Z StartDate EndDate percentage calculation https://community.qlik.com/t5/QlikView/StartDate-EndDate-percentage-calculation/m-p/807414#M1028704 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>learning Qlik for about 3 weeks ))) and </P><P></P><P>I need your help with simple task I have.</P><P></P><P>Data set:</P><P></P><P>name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Time- date&nbsp;&nbsp; price</P><P>a1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>a2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22</P><P>a3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>a4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 24</P><P>b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>b2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15</P><P>b3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30</P><P>b4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Jan 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33</P><P></P><P>Task: calculate % between two dates I choose with vStartDate and vEndDate variables and visualize it as Block Chart.</P><P></P><P>I feel that it could be really simple, but have not got the logic yet (((.&nbsp; </P></BODY></HTML> Sat, 14 Feb 2015 16:26:02 GMT https://community.qlik.com/t5/QlikView/StartDate-EndDate-percentage-calculation/m-p/807414#M1028704 2015-02-14T16:26:02Z Re: StartDate EndDate percentage calculation https://community.qlik.com/t5/QlikView/StartDate-EndDate-percentage-calculation/m-p/807415#M1028705 <HTML><HEAD></HEAD><BODY><P>I've worked it out using the expression</P><P></P><P>=Num (1-( FirstSortedValue([Close], [Time-Date], 1)&nbsp; / FirstSortedValue([Close], -1*[Time-Date], 1) ))*100</P><P></P><P>not sure if this is a correct one, however it works for now, but not as Block Chart (won't show negative values with positive), thus I use Bar Chart temporarily.</P></BODY></HTML> Sat, 14 Feb 2015 19:13:36 GMT https://community.qlik.com/t5/QlikView/StartDate-EndDate-percentage-calculation/m-p/807415#M1028705 2015-02-14T19:13:36Z