Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

13-11-_2015_14-46-06.png

1 Reply
maxgro
MVP
MVP

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