Use filter to show different table row

[stefanmshs]

Hello,

I did not find a better title. It could be misleading.

I have to following table:

dim1	dim2	x
0	123	-
1	124	123

Is it possible that I set a filter on dim2 (=123) and the row with x=dim2 is shown aswell? Per default I only get the row with dim1=0 because of the qlik filtering logic. I already tried sth. like this:

only({<x= P(dim2)>} x) 

but the dimesion is shrinked by filtering dim2 and the row with the expression is never shown.

Is this somehow possible?

[stefanmshs · Accepted solution]

Reply to myself...

One character more and it works 😄

only({1<x= P(dim2)>} x)

There is a "1" more.