topic Re: Need Help on case statement in QlikView https://community.qlik.com/t5/QlikView/Need-Help-on-case-statement/m-p/1433009#M804528 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>If(Key&lt;10, 1,</P><P><SPAN style="font-size: 13.3333px;">If(Key&lt;50, 2,</SPAN></P><P><SPAN style="font-size: 13.3333px;">If(Key&lt;500, 3,</SPAN></P><P><SPAN style="font-size: 13.3333px;">If(Key&lt;3000, 4,</SPAN></P><P><SPAN style="font-size: 13.3333px;">If(Key&lt;8678, 5,</SPAN></P><P><SPAN style="font-size: 13.3333px;">If(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PARTY_RISK_SCORE_RV</SPAN>&lt;10000, 6,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">If(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PARTY_RISK_SCORE_RV</SPAN><SPAN style="font-size: 13.3333px;">&gt;=10000, 7</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">))))))) as level<BR /></SPAN></P></BODY></HTML> Wed, 08 Nov 2017 05:57:26 GMT Sergey_Shuklin 2017-11-08T05:57:26Z Need Help on case statement https://community.qlik.com/t5/QlikView/Need-Help-on-case-statement/m-p/1433008#M804527 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P>Can any one convert below code to qlikview</P><P>case when Key&lt;10 then 1</P><P>when Key&lt;50 then 2</P><P>when Key&lt;500 then 3</P><P>when Key&lt; 3000 then 4</P><P>when Key&lt; 8678 then 5</P><P>when PARTY_RISK_SCORE_RV&lt;10000 then 6</P><P>when PARTY_RISK_SCORE_RV&gt;=10000 then 7</P><P>end level</P><P></P><P>Thanks,</P><P>Chinnu.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-Help-on-case-statement/m-p/1433008#M804527 chinnu123 2020-11-25T16:16:04Z Re: Need Help on case statement https://community.qlik.com/t5/QlikView/Need-Help-on-case-statement/m-p/1433009#M804528 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>If(Key&lt;10, 1,</P><P><SPAN style="font-size: 13.3333px;">If(Key&lt;50, 2,</SPAN></P><P><SPAN style="font-size: 13.3333px;">If(Key&lt;500, 3,</SPAN></P><P><SPAN style="font-size: 13.3333px;">If(Key&lt;3000, 4,</SPAN></P><P><SPAN style="font-size: 13.3333px;">If(Key&lt;8678, 5,</SPAN></P><P><SPAN style="font-size: 13.3333px;">If(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PARTY_RISK_SCORE_RV</SPAN>&lt;10000, 6,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">If(</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">PARTY_RISK_SCORE_RV</SPAN><SPAN style="font-size: 13.3333px;">&gt;=10000, 7</SPAN></SPAN></P><P><SPAN style="font-size: 13.3333px;">))))))) as level<BR /></SPAN></P></BODY></HTML> Wed, 08 Nov 2017 05:57:26 GMT https://community.qlik.com/t5/QlikView/Need-Help-on-case-statement/m-p/1433009#M804528 Sergey_Shuklin 2017-11-08T05:57:26Z