topic Re: Levels of Distribution in QlikView

Levels of Distribution

Wed, 19 Aug 2015 17:13:54 GMT

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.

Re: Levels of Distribution

swuehl — Wed, 19 Aug 2015 17:56:35 GMT

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?

Re: Levels of Distribution

Fri, 21 Aug 2015 05:43:05 GMT

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

Re: Levels of Distribution

MarcoWedel — Fri, 21 Aug 2015 08:09:22 GMT

Are there two different amount fields?

Please post sample data and expected result.

Thanks

Regards

Marco

Re: Levels of Distribution

jonathandienst — Fri, 21 Aug 2015 08:17:53 GMT

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)