topic Re: WTD, MTD Analysis in QlikView

WTD, MTD Analysis

girish_talele — Wed, 25 Nov 2020 16:16:04 GMT

Dear Experts,

In a production analysis we are building an analysis for WTD & MTD, wherein we have data as shown in below table 1.

The requirement is as shown in second table.

We could achieve WTD & MTD Values for individual Segment (i.e. Qty, Value, Cost), but struggling to achieve requirement.

Please suggest on the same.

Regards,

Girish.

Re: WTD, MTD Analysis

ecolomer — Sat, 20 Aug 2016 06:39:36 GMT

Is this you need?

Re: WTD, MTD Analysis

girish_talele — Sat, 20 Aug 2016 07:11:34 GMT

Dear Enrique Colomer,

Yes, this is what I needed... amazing & perfect solution .

Thank you very much.

Regards,

Girish.

Re: WTD, MTD Analysis

ecolomer — Sat, 20 Aug 2016 07:27:07 GMT

You are welcome

Saludos,

Enrique Colomer

Re: WTD, MTD Analysis

sunny_talwar — Sat, 20 Aug 2016 10:26:36 GMT

Although this post has already been closed and resolved, but I thought I would provide an idea for a slight improvement. Currently the expressions from ecolomer‌ are using if statements, but I think we can do the same using set analysis. Set analysis is better here because it is going to give better performance compared to the if statement because set analysis is evaluated once per chart, where as if is evaluated on each dimension. In this particular case, I see no reason for evaluation on each row and therefore I feel that set analysis might be a better option

Chart3 is using if statement and Chart 4 is using set analysis.

HTH

Best,

Sunny

P.S. I used qvw in Enrique's response and made additions in there

Re: WTD, MTD Analysis

ecolomer — Sat, 20 Aug 2016 15:52:37 GMT

Very good solution, stalwar1‌

Good solution, but I did not care formulas and used which already had, and gave a solution to how to present that was his concern.

Enrique

Re: WTD, MTD Analysis

sunny_talwar — Sat, 20 Aug 2016 17:00:57 GMT

That makes perfect sense

I just wanted to provide a set analysis based solution to the problem.