topic Aggregate Metric at parent level in QlikView

Aggregate Metric at parent level

Mon, 15 Oct 2012 06:44:25 GMT

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.

Re: Aggregate Metric at parent level

Mon, 15 Oct 2012 08:02:07 GMT

Hi,

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

Regards,

Janzen

Re: Aggregate Metric at parent level

Mon, 15 Oct 2012 08:39:08 GMT

Thanks Janzen for a speedy reply.

But this works only when Product is not selected.

Re: Aggregate Metric at parent level

Mon, 15 Oct 2012 08:54:21 GMT

Hi,

I have updated the previous file.

Regards,

Janzen

Re: Aggregate Metric at parent level

kaushiknsolanki — Mon, 15 Oct 2012 08:55:32 GMT

Here is your solution.

Regards,

Kaushik Solanki

Re: Aggregate Metric at parent level

Mon, 15 Oct 2012 09:13:12 GMT

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.

Re: Aggregate Metric at parent level

Mon, 15 Oct 2012 09:18:07 GMT

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

Re: Aggregate Metric at parent level

Mon, 15 Oct 2012 09:26:13 GMT

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.

Re: Aggregate Metric at parent level

Mon, 15 Oct 2012 10:27:50 GMT

Found the solution on this thread:

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