Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)