topic Re: Value lies between which Range in QlikView https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724678#M259998 <HTML><HEAD></HEAD><BODY><P>I have already mentioned that I have to do it in UI part not in script part. </P></BODY></HTML> Wed, 06 Aug 2014 11:15:39 GMT koushik_btech20 2014-08-06T11:15:39Z Value lies between which Range https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724673#M259993 <HTML><HEAD></HEAD><BODY><P>I have a table which contains the lower bound ,higher bound and a flag(Msg)&nbsp; and in another table I have attribute wise score. I have to find the score first and match it&nbsp; with the range(lower bound and upper bound) and display the msg in a text object. I am attaching a qvw. If anyone have any idea please share here.</P></BODY></HTML> Wed, 06 Aug 2014 10:35:12 GMT https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724673#M259993 koushik_btech20 2014-08-06T10:35:12Z Re: Value lies between which Range https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724674#M259994 <HTML><HEAD></HEAD><BODY><P>Try using Intervalmatch().</P></BODY></HTML> Wed, 06 Aug 2014 10:39:53 GMT https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724674#M259994 tresB 2014-08-06T10:39:53Z Re: Value lies between which Range https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724675#M259995 <HTML><HEAD></HEAD><BODY><P>Interval match&nbsp; function is used in script. But I have to do it in UI section.</P></BODY></HTML> Wed, 06 Aug 2014 10:44:40 GMT https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724675#M259995 koushik_btech20 2014-08-06T10:44:40Z Re: Value lies between which Range https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724676#M259996 <HTML><HEAD></HEAD><BODY><P>vAvg=Avg(Score)</P><P>Expression in th textbox:</P><P>=Concat( distinct if(vAvg&gt;=LowerBound and vAvg&lt;=HigherBound, Msg))</P></BODY></HTML> Wed, 06 Aug 2014 10:56:19 GMT https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724676#M259996 tresB 2014-08-06T10:56:19Z Re: Value lies between which Range https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724677#M259997 <HTML><HEAD></HEAD><BODY><P>please find the attached, I hope it matches your request <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 06 Aug 2014 11:01:38 GMT https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724677#M259997 Yousef_Amarneh 2014-08-06T11:01:38Z Re: Value lies between which Range https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724678#M259998 <HTML><HEAD></HEAD><BODY><P>I have already mentioned that I have to do it in UI part not in script part. </P></BODY></HTML> Wed, 06 Aug 2014 11:15:39 GMT https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724678#M259998 koushik_btech20 2014-08-06T11:15:39Z Re: Value lies between which Range https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724679#M259999 <HTML><HEAD></HEAD><BODY><P>These expression not works.</P></BODY></HTML> Wed, 06 Aug 2014 11:17:39 GMT https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724679#M259999 koushik_btech20 2014-08-06T11:17:39Z Re: Re: Value lies between which Range https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724680#M260000 <HTML><HEAD></HEAD><BODY><P>Did you note that vAvg is a variable?</P><P>See attached qvw.</P></BODY></HTML> Wed, 06 Aug 2014 11:20:38 GMT https://community.qlik.com/t5/QlikView/Value-lies-between-which-Range/m-p/724680#M260000 tresB 2014-08-06T11:20:38Z