Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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.