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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Color value in Straight Table

Hi,

i've a question about value color in two different tables:

Example:

TAB1    TAB2

Col1    Col1

A      A

B      B

C      D

D      H

My achieve is to color common values but in TAB 2 ( in this case  A, B , D )

It's possible to make in a expression?

Thank you in advance

Labels (1)
5 Replies
Anil_Babu_Samineni
MVP
MVP

Why D from Tab2 need Color?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Beacause D is present in TAB1.

I want new values in TAB2 colored.

Any suggests?

Anil_Babu_Samineni
MVP
MVP

Can you attach qvw?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

No

Anil_Babu_Samineni
MVP
MVP

Okay, Can you try this one. I used QUALIFY Statement..

If(T1.Col1 = Only({<T1.Col1 = P(T2.Col1)>} T1.Col1), Blue())

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful