Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Aggregate Metric at parent level

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.

1 Solution

Accepted Solutions
Not applicable

Re: Aggregate Metric at parent level

Hi,

I have updated the previous file.

Regards,

Janzen

8 Replies
Not applicable

Re: Aggregate Metric at parent level

Hi,

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

Regards,

Janzen

Not applicable

Re: Aggregate Metric at parent level

Thanks Janzen for a speedy reply.

But this works only when Product is not selected.

Not applicable

Re: Aggregate Metric at parent level

Hi,

I have updated the previous file.

Regards,

Janzen

Re: Aggregate Metric at parent level

Here is your solution.

Regards,

Kaushik Solanki

Not applicable

Re: Aggregate Metric at parent level

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.

Not applicable

Re: Aggregate Metric at parent level

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

Not applicable

Re: Aggregate Metric at parent level

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.

Not applicable

Re: Aggregate Metric at parent level

Found the solution on this thread:

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

Community Browser