Lookup Data unrelated Table for Chart

Danijel — Mon, 29 Mar 2021 16:24:45 GMT

Hello all,

I'm trying to solve a problem that I'm stuck on after hours.

The problem is that I calculate a value X, for this value a value must be set from a second table (not connected). I can't connect the whole thing, because the reference has to happen dynamically on the surface for each filtering.

In the meantime I have tried the following:
- p()
- wildmatch
- if

But never with a really satisfying solution.

Maybe someone else has an idea?

Attached is an example file.

Thank you.

Greetings

Re: Lookup Data unrelated Table for Chart

MayilVahanan — Tue, 30 Mar 2021 02:55:29 GMT

Hi @Danijel

Try like below

minstring(Aggr(if(sum(Value)=TValue,T%,'na'), T%, Dim))

Re: Lookup Data unrelated Table for Chart

MayilVahanan — Tue, 30 Mar 2021 02:56:19 GMT

o/p:

topic Re: Lookup Data unrelated Table for Chart in QlikView

Lookup Data unrelated Table for Chart

Re: Lookup Data unrelated Table for Chart

Re: Lookup Data unrelated Table for Chart