topic is this proper in QV? in QlikView

is this proper in QV?

avastani — Fri, 23 Oct 2009 11:28:08 GMT

I am looking to get analysis on the Territory level but where where all roll up to a Region and regions rolling into a Division. I use the Terr field from the Geography and the Region field from the Product table and the Division from Geography.

Or should I use all three dimensions from the Geography table? If I use all 3 dimensions from the Geograhpy table, my charts are incorrect because all Territories show the exact same sales. but when I do the split as Territory and Division from Geography and the Region from Product, I get unique results for each territory and region and division. Why is that? Based on my schema, I should have gotten the same result either ways but it is not so. Thanks in advance for your help.

is this proper in QV?

Fri, 23 Oct 2009 15:01:09 GMT

If you use all 3 dimensions from the Geograhpy table and all Territories show the exact same sales, then probably all territories have the same GeoOrgGUID. Suggest you to check it once, the territories should have different GeoOrdGUID.

If the IDs are different, then I need to take a look at the qvw file before coming to any conclusion.

Thanks

Amit

is this proper in QV?

avastani — Fri, 23 Oct 2009 19:19:41 GMT

The IDs are different. I don't mind taking this discussion offline if you don't mind. I am at amirali@gmx.us

thanks.

is this proper in QV?

Tue, 27 Oct 2009 13:00:13 GMT

In case the issue is not resolved, you can mail me the details @ agrawami@gmail.com

Thanks

Amit