topic Select Distinct Expressions in QlikView https://community.qlik.com/t5/QlikView/Select-Distinct-Expressions/m-p/228690#M80696 <HTML><HEAD></HEAD><BODY><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1012_sourceID:1012" />Hi Dears!</P><P>I'm developing a application on QlikView. But I have a problem when I<BR />use a expressions to count the amount of products.</P><P>I attached a screenshot that show a little bit my problem (REPORT_ACTUAL.png).</P><P>The dimension "Qtde Transações" (last column) makes the expression follows below:</P><P>count(distinct V320DOCAUTCLI) - The field V320DOCATUCLI is dimension "Autorização"</P><P><BR />But I need to elimite the values doesn't considered in the count. Follows below<BR />a screenshot that I did to examply how to values should be showed (REPORT_EXPECTED.png).</P><P>How can I changes the report to show values as well the screenshot REPORT_EXPECTED.png?</P><P>Thank you everybody who can help me.</P><P>Fernando Vieira<BR />Analyst BI<BR />Sao Paulo - Brazil</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1013_sourceID:1013" /></P><P><BR /></P><P></P><P></P></BODY></HTML> Tue, 02 Feb 2010 13:23:02 GMT 2010-02-02T13:23:02Z Select Distinct Expressions https://community.qlik.com/t5/QlikView/Select-Distinct-Expressions/m-p/228690#M80696 <HTML><HEAD></HEAD><BODY><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1012_sourceID:1012" />Hi Dears!</P><P>I'm developing a application on QlikView. But I have a problem when I<BR />use a expressions to count the amount of products.</P><P>I attached a screenshot that show a little bit my problem (REPORT_ACTUAL.png).</P><P>The dimension "Qtde Transações" (last column) makes the expression follows below:</P><P>count(distinct V320DOCAUTCLI) - The field V320DOCATUCLI is dimension "Autorização"</P><P><BR />But I need to elimite the values doesn't considered in the count. Follows below<BR />a screenshot that I did to examply how to values should be showed (REPORT_EXPECTED.png).</P><P>How can I changes the report to show values as well the screenshot REPORT_EXPECTED.png?</P><P>Thank you everybody who can help me.</P><P>Fernando Vieira<BR />Analyst BI<BR />Sao Paulo - Brazil</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1013_sourceID:1013" /></P><P><BR /></P><P></P><P></P></BODY></HTML> Tue, 02 Feb 2010 13:23:02 GMT https://community.qlik.com/t5/QlikView/Select-Distinct-Expressions/m-p/228690#M80696 2010-02-02T13:23:02Z