topic Help needed please in QlikView https://community.qlik.com/t5/QlikView/Help-needed-please/m-p/550458#M205576 <HTML><HEAD></HEAD><BODY><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rating:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><P>Avg(Timelinessscore)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;60%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48-59%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 36-47%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;36%</P><P></P><P>i need to write an expression for a bar chart which displays only rating&nbsp;&nbsp; </P><P>with another condition Timeliness&lt;&gt;0.</P><P></P><P>i have written this expression,but this seems to be worse.</P><P><SPAN style="color: #008000; font-family: arial; font-size: x-small;"><BR /></SPAN></P><P><SPAN style="color: #008000; font-size: 12pt; font-family: arial;">= if (Timeliness&lt;&gt;0 , </SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #008000; font-family: arial;">if(Avg(Timelinessscore)&gt;=0.6,</SPAN><SPAN style="color: #008000; font-family: arial;">4,</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="line-height: 1.5em; color: #008000; font-family: arial;">if(Avg(Timelinessscore)&gt;=0.48,</SPAN><SPAN style="line-height: 1.5em; color: #008000; font-family: arial;">3,</SPAN></SPAN></P><P><SPAN style="line-height: 1.5em; color: #008000; font-size: 12pt; font-family: arial;"> if(Avg(Timelinessscore)&gt;=0.36,</SPAN><SPAN style="line-height: 1.5em; color: #008000; font-size: 12pt; font-family: arial;">2 , 1 )))</SPAN></P><P><SPAN style="line-height: 1.5em; color: #008000; font-size: 12pt; font-family: arial;"><BR /></SPAN></P><P><SPAN style="line-height: 1.5em; color: #008000; font-size: 12pt; font-family: arial;">please help me out in rewriting this expression. thanks<BR /></SPAN></P></BODY></HTML> Mon, 09 Dec 2013 23:39:46 GMT Qrishna 2013-12-09T23:39:46Z Help needed please https://community.qlik.com/t5/QlikView/Help-needed-please/m-p/550458#M205576 <HTML><HEAD></HEAD><BODY><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rating:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1</P><P></P><P>Avg(Timelinessscore)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =&gt;60%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 48-59%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 36-47%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;36%</P><P></P><P>i need to write an expression for a bar chart which displays only rating&nbsp;&nbsp; </P><P>with another condition Timeliness&lt;&gt;0.</P><P></P><P>i have written this expression,but this seems to be worse.</P><P><SPAN style="color: #008000; font-family: arial; font-size: x-small;"><BR /></SPAN></P><P><SPAN style="color: #008000; font-size: 12pt; font-family: arial;">= if (Timeliness&lt;&gt;0 , </SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="color: #008000; font-family: arial;">if(Avg(Timelinessscore)&gt;=0.6,</SPAN><SPAN style="color: #008000; font-family: arial;">4,</SPAN></SPAN></P><P><SPAN style="font-size: 12pt;"><SPAN style="line-height: 1.5em; color: #008000; font-family: arial;">if(Avg(Timelinessscore)&gt;=0.48,</SPAN><SPAN style="line-height: 1.5em; color: #008000; font-family: arial;">3,</SPAN></SPAN></P><P><SPAN style="line-height: 1.5em; color: #008000; font-size: 12pt; font-family: arial;"> if(Avg(Timelinessscore)&gt;=0.36,</SPAN><SPAN style="line-height: 1.5em; color: #008000; font-size: 12pt; font-family: arial;">2 , 1 )))</SPAN></P><P><SPAN style="line-height: 1.5em; color: #008000; font-size: 12pt; font-family: arial;"><BR /></SPAN></P><P><SPAN style="line-height: 1.5em; color: #008000; font-size: 12pt; font-family: arial;">please help me out in rewriting this expression. thanks<BR /></SPAN></P></BODY></HTML> Mon, 09 Dec 2013 23:39:46 GMT https://community.qlik.com/t5/QlikView/Help-needed-please/m-p/550458#M205576 Qrishna 2013-12-09T23:39:46Z Re: Help needed please https://community.qlik.com/t5/QlikView/Help-needed-please/m-p/550459#M205577 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Can you attach some sample file?</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Tue, 10 Dec 2013 03:29:16 GMT https://community.qlik.com/t5/QlikView/Help-needed-please/m-p/550459#M205577 jagan 2013-12-10T03:29:16Z