Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Femke_DPG
Contributor III
Contributor III

Only show above dimension when duplicate

Hi experts, 

I only want to see the name of the payer (in black to anonymiser)

Femke_DPG_0-1654778127778.png

If the 2th dimension has the same value as the 1th, it shows null() because I installed it that way. That's quite ok, but I want to not see the '-' either. 

So I want to see the first and second dimension when the 2th is different and only the first dimension when the 2th is the same

In fact, here I want to show only the black rows. 

When I untick 'Include null values', it only shows this, so the rest disappears:

Femke_DPG_1-1654778341435.png

 

Thank you for helping me on this! 

Appreciate your help

Femke

 

 

Labels (1)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

Why not just change the Text Color to White for Dimension2?

 

=if(Dimension1=Dimension2,white(),black())

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

Why not just change the Text Color to White for Dimension2?

 

=if(Dimension1=Dimension2,white(),black())

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.