Distinct value Set analysis

[shanky1907]

Hello All,

I have an issue with one of the applications. I have data according to Geographical hierarchy Like:

Country-> District-> Area...

There are customers who have some country, District and Area.

For some Custoemrs, the field area is blank. So for these custoemrs, the application is summing data for all areas under the district defined.

Ca nyou tell me how i can apply distinct or to sum sitinct values when the area is blank?

[jonathandienst]

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.

[#3]

You can check the option 'Suppress when null values '