Big Challenge Triangle

[christian77]

Hi.

I have attached an example in Excel.

They are 2 tables. The first one is already solved by crossing those 2 years.

I need to solve the second one using QlikView.

It is like a sudoku. It is difficult to solve in QlikView.

I need some help with it please.

Thanks.

Message was edited by: Christian Conejero I've changed the attachment. Sorry.

[christian77]

Nothing?

Ok.

[simondachstr]

Have you tried working with ValueList()?

[christian77]

Thanks for your answer.

I'll check that out.

[rbecher]

Hi Christian,

please find attached solution.

- Ralf

[rbecher · Accepted solution]

Hi Chris,

have you checked the solution I've posted?

- Ralf

[christian77]

Hi Ralf.

Thank you.

I still need a couple more things but your answer is correct.

Bite.

[christian77]

Hi.

Thanks. I didn't know that funcktion.

How many times I have loaded an inline fake dimensión! I won't do it again.

Bite.