topic Re: Relative graph in QlikView https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304169#M618397 <HTML><HEAD></HEAD><BODY><P>Every day you learn something!</P><P>thank you very much</P></BODY></HTML> Mon, 22 May 2017 13:47:21 GMT cattaneoc 2017-05-22T13:47:21Z Relative graph https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304163#M618391 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P></P><P>How can I convert the graphic attached to the image?</P><P></P><P></P><P>Thank you!</P><P></P><P><IMG alt="Imagen2.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/164097_Imagen2.jpg" style="height: auto;" /></P></BODY></HTML> Fri, 19 May 2017 20:47:19 GMT https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304163#M618391 cattaneoc 2017-05-19T20:47:19Z Re: Relative graph https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304164#M618392 <HTML><HEAD></HEAD><BODY><P>As expression</P><P></P><P>Count(Poliza)</P><P><STRONG>/</STRONG></P><P><STRONG>Count(TOTAL&lt;Combustible&gt; Poliza)</STRONG></P><P></P><P>and format number as percentage on number tab</P></BODY></HTML> Fri, 19 May 2017 21:07:01 GMT https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304164#M618392 swuehl 2017-05-19T21:07:01Z Re: Relative graph https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304165#M618393 <HTML><HEAD></HEAD><BODY><P>Excellent! And could you rewrite the sentence if the dimension is a cyclic group?</P><P></P><P><IMG alt="Grupo ciclico.jpg" class="jive-image image-1" src="/legacyfs/online/164108_Grupo ciclico.jpg" style="height: 487px; width: 620px;" /></P></BODY></HTML> Fri, 19 May 2017 21:25:57 GMT https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304165#M618393 cattaneoc 2017-05-19T21:25:57Z Re: Relative graph https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304166#M618394 <HTML><HEAD></HEAD><BODY><P>Either add all field names that are part of the dimension group to the TOTAL qualifier field list or use GetCurrentField():</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Count(TOTAL&lt;Combustible, AnotherFieldName1, AnotherFieldName2&gt; Poliza)</STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><BR /></STRONG></P><P>Or </P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Count(TOTAL&lt;[$(=GetCurrentField( "Group Cyclico"))]&gt; Poliza)</STRONG></P></BODY></HTML> Fri, 19 May 2017 21:29:18 GMT https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304166#M618394 swuehl 2017-05-19T21:29:18Z Re: Relative graph https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304167#M618395 <HTML><HEAD></HEAD><BODY><P>It works! thank you very much. Why is the formula Underline in red?<IMG alt="Subrayado en rojo.jpg" class="jive-image image-1" src="/legacyfs/online/164275_Subrayado en rojo.jpg" style="height: auto;" /></P></BODY></HTML> Mon, 22 May 2017 13:17:26 GMT https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304167#M618395 cattaneoc 2017-05-22T13:17:26Z Re: Relative graph https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304168#M618396 <HTML><HEAD></HEAD><BODY><P>That's because the syntax checker can't really handle the dollar sign expansions $(=...)</P><P>It's a limitation of the checker, so you need to test the result yourself.</P></BODY></HTML> Mon, 22 May 2017 13:42:40 GMT https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304168#M618396 swuehl 2017-05-22T13:42:40Z Re: Relative graph https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304169#M618397 <HTML><HEAD></HEAD><BODY><P>Every day you learn something!</P><P>thank you very much</P></BODY></HTML> Mon, 22 May 2017 13:47:21 GMT https://community.qlik.com/t5/QlikView/Relative-graph/m-p/1304169#M618397 cattaneoc 2017-05-22T13:47:21Z