Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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)