topic ? in QlikView https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325374#M618166 <P>.</P> Sun, 14 Apr 2019 15:09:19 GMT xyz1 2019-04-14T15:09:19Z ? https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325368#M618158 <P>.</P> Sun, 14 Apr 2019 15:12:32 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325368#M618158 xyz1 2019-04-14T15:12:32Z Re: Condition check https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325369#M618159 <HTML><HEAD></HEAD><BODY><P>Please check</P><P></P><P>LOAD "ProjectCPI",</P><P>IF("ProjectCPI" &lt; 0.75, 'OverBudget',</P><P>IF("ProjectCPI" &gt;= 0.75 and "ProjectCPI" &lt;= 0.85 ,&nbsp; 'Within Budget',</P><P>if("ProjectCPI" &gt; 0.85 ,</P><P>'Under Budget' ))) as CostClassification</P><P></P><P>Or </P><P></P><P></P><P></P><P>LOAD "ProjectCPI",</P><P>IF("ProjectCPI" &lt; 0.75, 'OverBudget', </P><P>IF("ProjectCPI" &gt;= 0.75 and "ProjectCPI" &lt;= 0.85 ,&nbsp; 'Within Budget',</P><P>'Under Budget' )) as CostClassification</P><P></P><P></P><P>Or share some sample app</P></BODY></HTML> Wed, 24 May 2017 07:27:37 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325369#M618159 prma7799 2017-05-24T07:27:37Z Re: Condition check https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325370#M618160 <HTML><HEAD></HEAD><BODY><P>Hi Agrim,</P><P></P><P><SPAN style="color: blue; font-size: 9.0pt; font-family: 'Courier New';"><STRONG>LOAD</STRONG></SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">"Project CPI"</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">,<BR /></SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">IF</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">"Project CPI"</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> &lt; 0.75, 'OverBudget', </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">IF</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;">(</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">"Project CPI"</SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: black;"> &lt;= 0.85,&nbsp; 'Within Budget','Under Budget' )) </SPAN><SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: blue;">as</SPAN> <SPAN style="font-size: 9.0pt; font-family: 'Courier New'; color: maroon;">CostClassification </SPAN></P></BODY></HTML> Wed, 24 May 2017 07:35:05 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325370#M618160 tamilarasu 2017-05-24T07:35:05Z Re: Condition check https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325371#M618161 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG><EM>LOAD "Project</EM></STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM><STRONG>CPI",</STRONG></EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><EM><STRONG>IF("Project CPI" &lt;0.75, 'OverBudget', </STRONG></EM></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG><EM>IF("Project CPI" &gt;0.85,'Under Budget','<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Within Budget</SPAN>')) as CostClassification</EM></STRONG></P></BODY></HTML> Wed, 24 May 2017 09:01:44 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325371#M618161 Kushal_Chawda 2017-05-24T09:01:44Z ? https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325372#M618163 <P>.</P> Sun, 14 Apr 2019 15:12:13 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325372#M618163 xyz1 2019-04-14T15:12:13Z Re: Condition check https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325373#M618164 <HTML><HEAD></HEAD><BODY><P>PFA....</P></BODY></HTML> Wed, 24 May 2017 12:01:56 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325373#M618164 prma7799 2017-05-24T12:01:56Z ? https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325374#M618166 <P>.</P> Sun, 14 Apr 2019 15:09:19 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325374#M618166 xyz1 2019-04-14T15:09:19Z Re: Condition check https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325375#M618167 <HTML><HEAD></HEAD><BODY><P>could you share some sample output ...</P><P></P><P>What exactly you want</P></BODY></HTML> Wed, 24 May 2017 12:22:44 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325375#M618167 prma7799 2017-05-24T12:22:44Z ? https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325378#M618172 <P>.</P> Sun, 14 Apr 2019 15:06:51 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325378#M618172 xyz1 2019-04-14T15:06:51Z Re: Condition check https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325379#M618174 <HTML><HEAD></HEAD><BODY><P>Hi Ajit ,</P><P></P><P>I already gave you that solution</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD "ProjectCPI",</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">IF("ProjectCPI" &lt; 0.75, 'OverBudget',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">IF("ProjectCPI" &gt;= 0.75 and "ProjectCPI" &lt;= 0.85 ,&nbsp; 'Within Budget',</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">if("ProjectCPI" &gt; 0.85 ,</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">'Under Budget' ))) as CostClassification</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"> Please check above.</P></BODY></HTML> Thu, 25 May 2017 05:11:55 GMT https://community.qlik.com/t5/QlikView/unreadable-title/m-p/1325379#M618174 prma7799 2017-05-25T05:11:55Z