topic Re: Set analysis Group by in QlikView

Set analysis Group by

shanky1907 — Wed, 05 Aug 2015 09:41:45 GMT

Hello,

i am facing an issue in which there is sales data according to geographical hierarchy as country -> Districts -> Bricks.

So i am takign the sum of sales. But when i select the sales data to be shown as Bricks, it is showing me much larger vlaue for the same country if i comapre it with the country sum.

Please suggest some solution or reason to this issue.

Thanks

Re: Set analysis Group by

sunny_talwar — Wed, 05 Aug 2015 09:44:05 GMT

Can you share the expression you are using right now?

Re: Set analysis Group by

shanky1907 — Wed, 05 Aug 2015 09:52:41 GMT

=(sum({</*Variable Comparison*/>} [Net SI value])+sum({</*Variable Comparison*/>}[Net SO value]))

These variables have nothing to do with the geography.

Re: Set analysis Group by

sunny_talwar — Wed, 05 Aug 2015 09:57:01 GMT

So Sum of Sales for District (for a particular country) is more than Sum of Sales for the country???

Re: Set analysis Group by

shanky1907 — Wed, 05 Aug 2015 10:41:56 GMT

for district and coutnry is same. But for Bricks it is much more for the same country

Re: Set analysis Group by

sasiparupudi1 — Wed, 05 Aug 2015 19:16:03 GMT

please post your application