reference from one year value to another not linked table year value

Fri, 13 Nov 2015 13:48:13 GMT

Hello,

I have the situation that i want to calculate a count distinct based on the year "Lieferjahr" but i want to show this in a bar chart where the dimension is ReklJahr and the both tables are not linked.

i tried to write

Count(distinct{$ <Empfänger={"=Lieferjahr=Reklmationen.ReklJahr"}>} Empfänger)

but this does not work, can someone help me?

thanks, Armin

Re: reference from one year value to another not linked table year value

maxgro — Fri, 13 Nov 2015 14:06:54 GMT

count({$ <Lieferjahr=P([Reklmationen.ReklJahr])>} Empfänger)

topic reference from one year value to another not linked table year value in QlikView

reference from one year value to another not linked table year value

Re: reference from one year value to another not linked table year value