topic formula help in QlikView https://community.qlik.com/t5/QlikView/formula-help/m-p/1167444#M379938 <HTML><HEAD></HEAD><BODY><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">Doubt</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">I have two tables hechamados and helchamadosHistoricos</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">hechamados -&gt; nrMaximoMinutosSolucao and helchamado</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">helchamadosHistoricos -&gt; nrMinutosUteis and helchamado</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">I have to add (helchamadosHistoricos -&gt; nrMinutosUteis) and vcerificar if it is greater than nrMaximoMinutosSolucao</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">Could someone tell how to do this in a simple table?</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">hechamados -&gt; nrMaximoMinutosSolucao and helchamado</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><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; 10 01</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">helchamadosHistoricos -&gt; nrMinutosUteis and helchamado</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 01</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8 01</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5 01</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">Soma (helchamadosHistoricos -&gt; nrMinutosUteis) = 15&gt; that hechamados -&gt; 10 nrMaximoMinutosSolucao then he ACCOUNT</SPAN></P></BODY></HTML> Tue, 21 Jun 2016 18:37:49 GMT Anonymous 2016-06-21T18:37:49Z formula help https://community.qlik.com/t5/QlikView/formula-help/m-p/1167444#M379938 <HTML><HEAD></HEAD><BODY><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">Doubt</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">I have two tables hechamados and helchamadosHistoricos</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">hechamados -&gt; nrMaximoMinutosSolucao and helchamado</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">helchamadosHistoricos -&gt; nrMinutosUteis and helchamado</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">I have to add (helchamadosHistoricos -&gt; nrMinutosUteis) and vcerificar if it is greater than nrMaximoMinutosSolucao</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">Could someone tell how to do this in a simple table?</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">hechamados -&gt; nrMaximoMinutosSolucao and helchamado</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><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; 10 01</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">helchamadosHistoricos -&gt; nrMinutosUteis and helchamado</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 01</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8 01</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><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;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5 01</SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;"> </SPAN></P><P style="font-size: 12pt; font-family: 'Times New Roman', serif; color: #222222;"><SPAN style="font-size: 11pt; font-family: Calibri, sans-serif; color: black;">Soma (helchamadosHistoricos -&gt; nrMinutosUteis) = 15&gt; that hechamados -&gt; 10 nrMaximoMinutosSolucao then he ACCOUNT</SPAN></P></BODY></HTML> Tue, 21 Jun 2016 18:37:49 GMT https://community.qlik.com/t5/QlikView/formula-help/m-p/1167444#M379938 Anonymous 2016-06-21T18:37:49Z