topic Show latest load order value in QlikView https://community.qlik.com/t5/QlikView/Show-latest-load-order-value/m-p/259442#M97920 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>Some pointers:</P><P>- build a rank when you load the dimensions to be able to filter these dimensions later with a set analysis</P><P>- take a look on function <STRONG>firstsortedvalue</STRONG>.I have not tested but I hope that if no sort weight is specified, the load order is used.</P><P>- I think you can use weekname with maxstring and minstring in a set analysis, but it's ugly.</P></BODY></HTML> Mon, 28 Nov 2011 10:43:51 GMT nstefaniuk 2011-11-28T10:43:51Z Show latest load order value https://community.qlik.com/t5/QlikView/Show-latest-load-order-value/m-p/259441#M97919 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P>I have a field called WeekName with values like - Week 1, Week 2, Week 3, Week 4</P><P></P><P>WeekName is my dimension, sum(Sales) is my expression,</P><P></P><P>When i select any month, i want to show only the latest week sales in that month in one table, also in another table i want to show previous week sales except latest week.</P><P></P><P>Any help.?</P><P></P><P>Renjith</P></BODY></HTML> Mon, 28 Nov 2011 10:24:28 GMT https://community.qlik.com/t5/QlikView/Show-latest-load-order-value/m-p/259441#M97919 renjithpl 2011-11-28T10:24:28Z Show latest load order value https://community.qlik.com/t5/QlikView/Show-latest-load-order-value/m-p/259442#M97920 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P></P><P>Some pointers:</P><P>- build a rank when you load the dimensions to be able to filter these dimensions later with a set analysis</P><P>- take a look on function <STRONG>firstsortedvalue</STRONG>.I have not tested but I hope that if no sort weight is specified, the load order is used.</P><P>- I think you can use weekname with maxstring and minstring in a set analysis, but it's ugly.</P></BODY></HTML> Mon, 28 Nov 2011 10:43:51 GMT https://community.qlik.com/t5/QlikView/Show-latest-load-order-value/m-p/259442#M97920 nstefaniuk 2011-11-28T10:43:51Z