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: 
Aanchal
Contributor II
Contributor II

Hide Values of columns in table

Dear All, 

Kindle help me in achieving 

TranKey Amount Refund Premium Mismatch
1 100   100 100
1 -30 -30   -30

 

This is my table in frontend where Trankey , Amount , refund and Premium are calculated on backend and for Mismatch is an expression 

=if(sign(min(total<Trankey> [Amount]))<>sign(max(total<Trankey>[Amount])),[Amount])

I have to show a condition in expression on frontend where Mismatch is coming Refund and Premium should be  Blank.

TranKey Amount Refund Premium Mismatch
1 100     100
1 -30     -30

 

This is the correct output i have to achieve.

Labels (1)
0 Replies