topic [TRICKY] Distinct count in QlikView https://community.qlik.com/t5/QlikView/TRICKY-Distinct-count/m-p/219903#M72873 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a data structure like below,</P><P>If i do Count distinct Supplier, i get my correct figure.<BR /><BR />Year | Supplier</P><P></P><P>BUT, when i have the following, same set of data but just adding new dimension, the figure shoot up high.</P><P>How can i make an expression for this structure but to have the same supplier count as the above structure?<BR /><BR />Year | Supplier | Functions</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 17 Feb 2011 12:57:15 GMT 2011-02-17T12:57:15Z [TRICKY] Distinct count https://community.qlik.com/t5/QlikView/TRICKY-Distinct-count/m-p/219903#M72873 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a data structure like below,</P><P>If i do Count distinct Supplier, i get my correct figure.<BR /><BR />Year | Supplier</P><P></P><P>BUT, when i have the following, same set of data but just adding new dimension, the figure shoot up high.</P><P>How can i make an expression for this structure but to have the same supplier count as the above structure?<BR /><BR />Year | Supplier | Functions</P><P></P><P>Thanks.</P></BODY></HTML> Thu, 17 Feb 2011 12:57:15 GMT https://community.qlik.com/t5/QlikView/TRICKY-Distinct-count/m-p/219903#M72873 2011-02-17T12:57:15Z