Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
girish_talele
Creator
Creator

WTD, MTD Analysis

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.

Capture.JPG

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.

1 Solution

Accepted Solutions
ecolomer
Master II
Master II

Is this you need?

P-Tabla.png

View solution in original post

6 Replies
ecolomer
Master II
Master II

Is this you need?

P-Tabla.png

girish_talele
Creator
Creator
Author

Dear Enrique Colomer,

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

Thank you very much.

Regards,

Girish.

ecolomer
Master II
Master II

You are welcome

Saludos,

Enrique Colomer

sunny_talwar

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

Capture.PNG

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

ecolomer
Master II
Master II

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.

BR

Enrique

sunny_talwar

That makes perfect sense

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