topic help needed with expression or any idea in the script in QlikView https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850472#M298308 <HTML><HEAD></HEAD><BODY><P>in the attached screen the for a given code and year.. i will get some percentage . And there is another table which will have percentage ranges.. based on the range values star values are given for each Code. In the attached example for code AAP2 and year 2014.. the Rate % is 47% (0.47) and in the range table it is given that for the code AAP2 there will be begin percentage and end percentage based on the range it should assign star 1. please advise how to write the expression. Thanks for your help.</P></BODY></HTML> Mon, 08 Jun 2015 18:37:51 GMT Anonymous 2015-06-08T18:37:51Z help needed with expression or any idea in the script https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850472#M298308 <HTML><HEAD></HEAD><BODY><P>in the attached screen the for a given code and year.. i will get some percentage . And there is another table which will have percentage ranges.. based on the range values star values are given for each Code. In the attached example for code AAP2 and year 2014.. the Rate % is 47% (0.47) and in the range table it is given that for the code AAP2 there will be begin percentage and end percentage based on the range it should assign star 1. please advise how to write the expression. Thanks for your help.</P></BODY></HTML> Mon, 08 Jun 2015 18:37:51 GMT https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850472#M298308 Anonymous 2015-06-08T18:37:51Z Re: help needed with expression or any idea in the script https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850473#M298309 <HTML><HEAD></HEAD><BODY><P>can anyone help me.. @massimo Gross</P></BODY></HTML> Mon, 08 Jun 2015 18:47:30 GMT https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850473#M298309 Anonymous 2015-06-08T18:47:30Z Re: help needed with expression or any idea in the script https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850474#M298310 <HTML><HEAD></HEAD><BODY><P>maybe with extended interval match in the script</P></BODY></HTML> Mon, 08 Jun 2015 18:49:15 GMT https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850474#M298310 maxgro 2015-06-08T18:49:15Z Re: help needed with expression or any idea in the script https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850475#M298311 <HTML><HEAD></HEAD><BODY><P>i dont have timestamp or date columns . Do you think .. it will still work.</P></BODY></HTML> Mon, 08 Jun 2015 18:51:55 GMT https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850475#M298311 Anonymous 2015-06-08T18:51:55Z Re: help needed with expression or any idea in the script https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850476#M298312 <HTML><HEAD></HEAD><BODY><P>If possible is there any syntax you can help me with <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P></BODY></HTML> Mon, 08 Jun 2015 18:52:54 GMT https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850476#M298312 Anonymous 2015-06-08T18:52:54Z Re: help needed with expression or any idea in the script https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850477#M298313 <HTML><HEAD></HEAD><BODY><P>@<A href="https://community.qlik.com/people/shankarece">shankarece</A></P></BODY></HTML> Mon, 08 Jun 2015 20:12:48 GMT https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850477#M298313 Anonymous 2015-06-08T20:12:48Z Re: help needed with expression or any idea in the script https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850478#M298314 <HTML><HEAD></HEAD><BODY><P>Can you please help me with this . if there is a chance.</P></BODY></HTML> Mon, 08 Jun 2015 20:13:13 GMT https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850478#M298314 Anonymous 2015-06-08T20:13:13Z Re: help needed with expression or any idea in the script https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850479#M298315 <HTML><HEAD></HEAD><BODY><P>(Aggr(If((rate%)&gt;=PtileBeg and (rate%)&lt;=PtileEnd,Star),Star,MEASURE_ID) )</P></BODY></HTML> Tue, 09 Jun 2015 15:46:41 GMT https://community.qlik.com/t5/QlikView/help-needed-with-expression-or-any-idea-in-the-script/m-p/850479#M298315 Anonymous 2015-06-09T15:46:41Z