Aggregate Metric at parent level

[#1]

Hi Guys,

I have a requirement to show the share of a product in its market (There are multiple markets).

Attached is a excel sheet showing what I want to achieve and qvw with calculation I'm using.

This works only when a product is selected.

Please help me with this.

[#2]

Hi,

Check on this file. This is based on your excel attached file.

Regards,

Janzen

[#3]

Thanks Janzen for a speedy reply.

But this works only when Product is not selected.

[#4 · Accepted solution]

Hi,

I have updated the previous file.

Regards,

Janzen

[kaushiknsolanki]

Here is your solution.

Regards,

Kaushik Solanki

[#6]

Works fine.

Is there a way to make this independent of month selection.

I tried adding Month=, in the set expression. But does not seem to affect it.

[#7]

Hi,

What do you mean by independent of month selection? Does my solution fix your problem? If it does, kindly mark as correct for future references.

Regards,

Janzen

[#8]

Hi,

What I mean is, even if I select a month, it should show me values for all 3 months in the chart.

Is this possible?

Thanks in advance.

[#9]

Found the solution on this thread:

http://community.qlik.com/message/233122