topic How to use the 'Case' in qlikview in Brasil https://community.qlik.com/t5/Brasil/How-to-use-the-Case-in-qlikview/m-p/1335823#M48606 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;">Olá sou novo com qlikview gostaria de saber como altero dados da consulta</SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;">no sql eu usaria algo assim mais quando tem colocar no script da erro diz que não aceita</SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;">dados em branco alguem saberia como fazer isso funcionar ou outra forma de fazer<BR /></SPAN></P><P><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">&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; case fc.sit_functional</SPAN></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When '01' then 'ativo</SPAN><SPAN style="color: black; font-family: Calibri, sans-serif; font-size: 11pt;">'</SPAN></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When '02' then 'inativo'</SPAN></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">&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; End,</SPAN></P></BODY></HTML> Thu, 06 Jul 2017 00:17:02 GMT wellington_silv 2017-07-06T00:17:02Z How to use the 'Case' in qlikview https://community.qlik.com/t5/Brasil/How-to-use-the-Case-in-qlikview/m-p/1335823#M48606 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;">Olá sou novo com qlikview gostaria de saber como altero dados da consulta</SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;">no sql eu usaria algo assim mais quando tem colocar no script da erro diz que não aceita</SPAN></P><P><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;">dados em branco alguem saberia como fazer isso funcionar ou outra forma de fazer<BR /></SPAN></P><P><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN></P><P><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">&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; case fc.sit_functional</SPAN></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When '01' then 'ativo</SPAN><SPAN style="color: black; font-family: Calibri, sans-serif; font-size: 11pt;">'</SPAN></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">&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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When '02' then 'inativo'</SPAN></P><P style="color: #222222; font-family: arial, sans-serif; font-size: 12.8px;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">&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; End,</SPAN></P></BODY></HTML> Thu, 06 Jul 2017 00:17:02 GMT https://community.qlik.com/t5/Brasil/How-to-use-the-Case-in-qlikview/m-p/1335823#M48606 wellington_silv 2017-07-06T00:17:02Z Re: How to use the 'Case' in qlikview https://community.qlik.com/t5/Brasil/How-to-use-the-Case-in-qlikview/m-p/1335824#M48607 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Pick(Match( fc.sit_functional, '01', '02'), 'ativo', 'inativo')</STRONG><SPAN style="color: #000000; font-size: 14.6667px; font-family: Calibri, sans-serif;"> </SPAN></P></BODY></HTML> Thu, 06 Jul 2017 17:09:04 GMT https://community.qlik.com/t5/Brasil/How-to-use-the-Case-in-qlikview/m-p/1335824#M48607 sunny_talwar 2017-07-06T17:09:04Z