topic Re: Case statement in Qlikview in QlikView https://community.qlik.com/t5/QlikView/Case-statement-in-Qlikview/m-p/476125#M1122416 <HTML><HEAD></HEAD><BODY><P><BR />Thank you.</P></BODY></HTML> Wed, 08 Jan 2014 03:36:35 GMT 2014-01-08T03:36:35Z Case statement in Qlikview https://community.qlik.com/t5/QlikView/Case-statement-in-Qlikview/m-p/476123#M1122412 <HTML><HEAD></HEAD><BODY><P><SPAN dir="ltr" style="font-family: 'Segoe UI'; color: #000000; font-size: 10pt;"><SPAN dir="ltr" style="font-family: 'Segoe UI'; color: #000000; font-size: 10pt;">How can I write this case statement in qlikview.&nbsp; </SPAN></SPAN></P><P style="font-family: 'Calibri','sans-serif'; font-size: 11pt;"> </P><P style="font-family: 'Calibri','sans-serif'; font-size: 11pt;"><SPAN style="font-family: 'Courier New'; color: blue; font-size: 10pt; border-color: blue;">case</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;"> </SPAN><SPAN style="font-family: 'Courier New'; color: blue; font-size: 10pt; border-color: blue;">when</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;"> t_accrual_month_end.CATEGORY </SPAN><SPAN style="font-family: 'Courier New'; color: gray; font-size: 10pt; border-color: gray;">not</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;"> </SPAN><SPAN style="font-family: 'Courier New'; color: gray; font-size: 10pt; border-color: gray;">in</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;"> (</SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt; border-color: red;">'4'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;">,</SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt; border-color: red;">'9'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;">,</SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt; border-color: red;">'16'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;">,</SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt; border-color: red;">'21'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;">,</SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt; border-color: red;">'22'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;">) </SPAN><SPAN style="font-family: 'Courier New'; color: blue; font-size: 10pt; border-color: blue;">then</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;"> </SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt; border-color: red;">'N'</SPAN></P><P style="font-family: 'Calibri','sans-serif'; font-size: 11pt;"><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><SPAN style="font-family: 'Courier New'; color: blue; font-size: 10pt; border-color: blue;">else</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;"> </SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt; border-color: red;">'Y'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;"> </SPAN><SPAN style="font-family: 'Courier New'; color: blue; font-size: 10pt; border-color: blue;">end</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;"> </SPAN><SPAN style="font-family: 'Courier New'; color: blue; font-size: 10pt; border-color: blue;">as</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;"> MISC_FEE_RECURR_FLG, </SPAN></P><P style="font-family: 'Calibri','sans-serif'; font-size: 11pt;"> </P><P style="font-family: 'Calibri','sans-serif'; font-size: 11pt;"><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt; border-color: black;">Thank you very much.</SPAN></P></BODY></HTML> Tue, 07 Jan 2014 16:16:32 GMT https://community.qlik.com/t5/QlikView/Case-statement-in-Qlikview/m-p/476123#M1122412 2014-01-07T16:16:32Z Re: Case statement in Qlikview https://community.qlik.com/t5/QlikView/Case-statement-in-Qlikview/m-p/476124#M1122414 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> you could use the match function:</P><P>if(match(<SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt;">t_accrual_month_end.CATEGORY,<SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt;">'4'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt;">,</SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt;">'9'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt;">,</SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt;">'16'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt;">,</SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt;">'21'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt;">,</SPAN><SPAN style="font-family: 'Courier New'; color: red; font-size: 10pt;">'22'</SPAN><SPAN style="font-family: 'Courier New'; color: black; font-size: 10pt;">)&gt;0, 'Y', 'N')</SPAN></SPAN></P><P><SPAN style="color: black; font-size: 10pt; font-family: 'Courier New';"><BR /></SPAN></P></BODY></HTML> Tue, 07 Jan 2014 16:19:14 GMT https://community.qlik.com/t5/QlikView/Case-statement-in-Qlikview/m-p/476124#M1122414 bbi_mba_76 2014-01-07T16:19:14Z Re: Case statement in Qlikview https://community.qlik.com/t5/QlikView/Case-statement-in-Qlikview/m-p/476125#M1122416 <HTML><HEAD></HEAD><BODY><P><BR />Thank you.</P></BODY></HTML> Wed, 08 Jan 2014 03:36:35 GMT https://community.qlik.com/t5/QlikView/Case-statement-in-Qlikview/m-p/476125#M1122416 2014-01-08T03:36:35Z