topic Re: Checkbox to include/exclude associated values from the calculation? in QlikView

Checkbox to include/exclude associated values from the calculation?

Thu, 05 Jun 2014 13:40:54 GMT

Hi,

I have two lists of companies: Parent Company and Children Company, Children Company has both Parents and Children values in it.

My client wants a checkbox saying include hierarchy, meaning that if they uncheck that box they only want to see Sum(Revenue) for the parent and not it's children.

To me it means that whatever is selected in the Parent Company should select the same value in Children company.

Example listboxes:

Parent Company

Children Company:

So I only want to have A selected from Children Company and disregard its children - A1 and A2.

Any idea?

Re: Checkbox to include/exclude associated values from the calculation?

Thu, 05 Jun 2014 13:51:17 GMT

Hi Katarzyna

may be you can add a flag in your table when children = parent use 1

then use that flag in expression

if(if Flag = 1, sum({<Flag={'1'}>} Revenue), sum(Revenue)

best regards

Chris

Re: Checkbox to include/exclude associated values from the calculation?

crusader_ — Thu, 05 Jun 2014 13:51:48 GMT

Hi,

You can achieve this in several ways.

One of them described here Hierarchy and Hierarchy Belongs to

It helps to create hierarchical listbox.

Or you could just add 2 dimensions in your chart ParentCompany and Child Company and make them with conditional visible in QV11. You can check how to create such things in this file

Hope this helps.

Andrei