topic Re: Help with Load Script in QlikView https://community.qlik.com/t5/QlikView/Help-with-Load-Script/m-p/614913#M1114592 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Fri, 21 Feb 2014 07:55:41 GMT Gysbert_Wassenaar 2014-02-21T07:55:41Z Help with Load Script https://community.qlik.com/t5/QlikView/Help-with-Load-Script/m-p/614912#M1114591 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Attached is the application with some Sample data ,</P><P>Can someone please help me getting the expected results as in Text Box... I need to get Min value out of years for a project and Min value out of Type values for a project. I can use minstring to get the earliest year , and by ranking the value and writing an expression for getting the Type value ... but i dont want these to be expression as i need to create drop downs for both of these columns to allow user selection.</P><P></P><P>Can someone please suggest how i can get the expected results by coding in the Load Script ,please note the conditions ,</P><P></P><P>One record should be displayed for each project , Year value should be min of all values per project and Type value should be min of Ranks per project</P><P></P><P>Thank you in advance!!</P></BODY></HTML> Fri, 21 Feb 2014 03:43:08 GMT https://community.qlik.com/t5/QlikView/Help-with-Load-Script/m-p/614912#M1114591 Anonymous 2014-02-21T03:43:08Z Re: Help with Load Script https://community.qlik.com/t5/QlikView/Help-with-Load-Script/m-p/614913#M1114592 <HTML><HEAD></HEAD><BODY><P>See attached qvw.</P></BODY></HTML> Fri, 21 Feb 2014 07:55:41 GMT https://community.qlik.com/t5/QlikView/Help-with-Load-Script/m-p/614913#M1114592 Gysbert_Wassenaar 2014-02-21T07:55:41Z