topic Re: Distinct value Set analysis in QlikView https://community.qlik.com/t5/QlikView/Distinct-value-Set-analysis/m-p/918537#M318437 <HTML><HEAD></HEAD><BODY><P>You can check the option 'Suppress when null values '</P></BODY></HTML> Tue, 11 Aug 2015 11:15:15 GMT 2015-08-11T11:15:15Z Distinct value Set analysis https://community.qlik.com/t5/QlikView/Distinct-value-Set-analysis/m-p/918535#M318435 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I <SPAN style="font-size: 10pt; line-height: 1.5em;">have an issue with one of the applications. I have data according to Geographical hierarchy Like:</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Country-&gt; District-&gt; Area...</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">There are customers who have some country, District and Area.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">For some Custoemrs, the field area is blank. So for these custoemrs, the application is summing data for all areas under the district defined.</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Ca nyou tell me how i can apply distinct or to sum sitinct values when the area is blank?</SPAN></P></BODY></HTML> Tue, 11 Aug 2015 10:16:37 GMT https://community.qlik.com/t5/QlikView/Distinct-value-Set-analysis/m-p/918535#M318435 shanky1907 2015-08-11T10:16:37Z Re: Distinct value Set analysis https://community.qlik.com/t5/QlikView/Distinct-value-Set-analysis/m-p/918536#M318436 <HTML><HEAD></HEAD><BODY><P>I don't understand your question. I suggest that you post a sample qvw application to illustrate your problem, as well as what expression(s) you have tried.</P></BODY></HTML> Tue, 11 Aug 2015 10:49:00 GMT https://community.qlik.com/t5/QlikView/Distinct-value-Set-analysis/m-p/918536#M318436 jonathandienst 2015-08-11T10:49:00Z Re: Distinct value Set analysis https://community.qlik.com/t5/QlikView/Distinct-value-Set-analysis/m-p/918537#M318437 <HTML><HEAD></HEAD><BODY><P>You can check the option 'Suppress when null values '</P></BODY></HTML> Tue, 11 Aug 2015 11:15:15 GMT https://community.qlik.com/t5/QlikView/Distinct-value-Set-analysis/m-p/918537#M318437 2015-08-11T11:15:15Z