topic Calculate only Child value when Parent value is selected. in QlikView

Calculate only Child value when Parent value is selected.

Anonymous — Mon, 06 Feb 2017 07:18:42 GMT

Hello again Qlik Masters,

Good day to you all.

I have a Fact table that consists of Regional and Value columns, like so.

I have a Dimension called Dim_Region table that consists of Regional and Area columns, like so.

Both tables are linked using the Regional columns.

Regional acts as the Parent and Area acts as the Child.

My objective is to create a straight table with expression to Sum the Value but based on the value of the children's value when the parent is selected.

Is there any workaround for this issue?

For Example:

When the user chooses Regional = NATIONAL, then the table should consists of Values of NATIONAL's children (REGIONAL A, REGIONAL B, REGIONAL C, REGIONAL D, REGIONAL E.....REGIONAL L). The expected result is shown below.

Note: The chart above is still hardcoded. So it is still wrong.

Thank you in advance. And feel free to ask if there's any question regarding my problem.

You can find it in the attached QVW

--Adam Ginza--

Re: Calculate only Child value when Parent value is selected.

rahulpawarb — Mon, 06 Feb 2017 09:24:24 GMT

Hello Adam,

Attached is the draft work around. Please correct me in case I misunderstood the requirement.

Regards!

Rahul

Re: Calculate only Child value when Parent value is selected.

tresB — Mon, 06 Feb 2017 09:34:02 GMT

May be like this:

SUM(

Fact_Flag = {"FCC"} ,

REGIONAL = p(AREA) ,

FACT = {'Volume in Sticks'} , SKU = {'Cigarette'}, YearMonth_Num = {"$(=MAX({<Fact_Flag={'FCC'}>}YearMonth_Num))"}

Value)

Re: Calculate only Child value when Parent value is selected.

Anonymous — Mon, 06 Feb 2017 11:52:58 GMT

Hi Tresesco,

Your solution seems to work for me.

Thank you all for your help.

--Adam Ginza--