Levels of Distribution

[#1]

Hi All,

I have one table which contains 3 dimensions and 2 expressions.

Dimensions are  : Region,Business,Category

Expressions are : Rate,Net Rate

My req is by default table should show Region as Dimension and the calculation of Net Rate is Sum(Amount) which is calculated based on all Business Dimension under that Region (If user expanded Asia Region then it should sum the value for all Business which are under Asia Region).

If user expanded from Region to Business then calculation of Net Rate is Sum(Amount) which is calculated based on all Category under that Business  and under the Region.

Like that it should calculate value based on next level but for Rate calculation we don't need this requirement as it should behave in default mannaer.

As of now we have same data for Region,Business,Category If anybody helps on this i'll change in original QVW.

Is there any possibility to do this, as per my analysis we can do this by using Dimensionality but i didn't get exact solution for this.

Below is the reference link :

http://quickdevtips.blogspot.in/2012/06/qlikview-aggregation-1.html

Did anybody face this scenario before? If yes please give me some suggestion to resolve this.

[swuehl]

Sorry, I didn't really get your requirement. Sounds like standard QV behaviour all the way, but I seem to be missing something.

What is your requested result?

[#3]

Hi Swuehi,

Thanks for reply.

Actually Amount value based on Region and Amount value based on Business is different.

By default it should calculate based on Business dimension. if user expands then it should calculate based on Category.

Please help me here.

Thanks,

Chiru

[MarcoWedel]

Are there two different amount fields?

Please post sample data and expected result.

Thanks

Regards

Marco

[jonathandienst]

This looks like a drill-down requirement, which is simple to implement in the front end.

• Create a drill down group group (
  • Open the Documenent Properties | Groups dialog. Click New...
  • Make sure the Drill-down Group option is selected
  • Give the group a name (eg 'RegionDrill')
  • Add the Region,Business,Category fields to the group
• Now use the group as a dimension instead of Region
• If you select a region, the drill group will automatically change to all the [Business] values in the region.
• If you select a business, the group will change to the [Category] values in the business.
• Click the Drill icon (little up arrow) on he chart to go back up the drill group (Category back to Business back to Region)