topic Re: AJUDA/HELP Expression in QlikView https://community.qlik.com/t5/QlikView/AJUDA-HELP-Expression/m-p/970404#M468199 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">Projetos previstos&nbsp; </SPAN>count(distinct {&lt;[<SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">DT_TRMN_PNJD_PRJD]</SPAN> = {"&lt;=$(=(today()))"} &gt;} [projeto])</P><P><SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">Projetos realizados <SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;"> </SPAN><SPAN style="font-size: 13.3333px;">count(distinct {&lt;[<SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">ID_STAT_PRJT </SPAN></SPAN><SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">]</SPAN><SPAN style="font-size: 13.3333px;"> ={0</SPAN></SPAN><SPAN style="font-size: 13.3333px; color: #333f50; font-family: Calibri; text-align: justify; line-height: 1.5em;">} [projeto])</SPAN></P></BODY></HTML> Fri, 18 Sep 2015 20:16:16 GMT 2015-09-18T20:16:16Z AJUDA/HELP Expression https://community.qlik.com/t5/QlikView/AJUDA-HELP-Expression/m-p/970402#M468197 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">Bom dia, </SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Preciso de um help para fazer um gráfico igual a ilustração abaixo:</SPAN></P><P></P><P style="text-align: justify;"><SPAN style="font-size: 16.0pt; font-family: Calibri; color: #333f50; font-weight: bold;">Filtro: </SPAN><SPAN style="font-size: 16.0pt; font-family: Calibri; color: #333f50;">ano atual</SPAN></P><P style="text-align: justify;"><SPAN style="font-size: 16.0pt; font-family: Calibri; color: #333f50; font-weight: bold;">Regra: </SPAN></P><P style="text-align: justify;"><SPAN style="font-size: 16.0pt; font-family: Calibri; color: #333f50;">Projetos previstos = Projetos com Data Término Planejada (DT_TRMN_PNJD_PRJD) menor ou igual à data atual.</SPAN></P><P style="text-align: justify;"><SPAN style="font-size: 16.0pt; font-family: Calibri; color: #333f50;">Projetos realizados = Projetos com status Concluído(ID_STAT_PRJT = 0(Finalizado) </SPAN><SPAN style="color: #333f50; font-family: Calibri; font-size: 16pt; line-height: 1.5em;">no portfólio.</SPAN></P><P style="text-align: justify;"><SPAN style="font-size: 16.0pt; font-family: Calibri; color: #333f50;"><BR /></SPAN></P><P style="text-align: justify;"><SPAN style="font-size: 16.0pt; font-family: Calibri; color: #333f50;"><IMG alt="Regras Dashboard.pptx - PowerPoint_3.jpg" class="jive-image image-1" src="/legacyfs/online/99243_Regras Dashboard.pptx - PowerPoint_3.jpg" style="height: auto;" /></SPAN></P></BODY></HTML> Thu, 17 Sep 2015 13:27:35 GMT https://community.qlik.com/t5/QlikView/AJUDA-HELP-Expression/m-p/970402#M468197 2015-09-17T13:27:35Z Re: AJUDA/HELP Expression https://community.qlik.com/t5/QlikView/AJUDA-HELP-Expression/m-p/970403#M468198 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Veja se funciona:</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>Use o "combo chart", coloque as duas dimensões</P><UL><LI><SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">DT_TRMN_PNJD_PRJD</SPAN></LI><LI><SPAN style="text-align: justify; color: #333f50; font-size: 21.3333px; font-family: Calibri;">ID_STAT_PRJT = 0</SPAN></LI></UL><P>e <SPAN style="font-size: 13.3333px;">retire as linhas,</SPAN></P><P><SPAN style="font-size: 13.3333px;">nas expressoes use um count(nome do campo)</SPAN></P></BODY></HTML> Fri, 18 Sep 2015 19:25:52 GMT https://community.qlik.com/t5/QlikView/AJUDA-HELP-Expression/m-p/970403#M468198 mvaugusto 2015-09-18T19:25:52Z Re: AJUDA/HELP Expression https://community.qlik.com/t5/QlikView/AJUDA-HELP-Expression/m-p/970404#M468199 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">Projetos previstos&nbsp; </SPAN>count(distinct {&lt;[<SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">DT_TRMN_PNJD_PRJD]</SPAN> = {"&lt;=$(=(today()))"} &gt;} [projeto])</P><P><SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">Projetos realizados <SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;"> </SPAN><SPAN style="font-size: 13.3333px;">count(distinct {&lt;[<SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">ID_STAT_PRJT </SPAN></SPAN><SPAN style="color: #333f50; font-family: Calibri; font-size: 21.3333px; text-align: justify;">]</SPAN><SPAN style="font-size: 13.3333px;"> ={0</SPAN></SPAN><SPAN style="font-size: 13.3333px; color: #333f50; font-family: Calibri; text-align: justify; line-height: 1.5em;">} [projeto])</SPAN></P></BODY></HTML> Fri, 18 Sep 2015 20:16:16 GMT https://community.qlik.com/t5/QlikView/AJUDA-HELP-Expression/m-p/970404#M468199 2015-09-18T20:16:16Z