Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlikview Experts,
Is it possible for the user to display one field's content if another field contains a specific text of string? For example in this case, I would like to create a List Box to display 'BCNo' Field if 'OM' Field contains "O". (Any other suggestions for better display of data will be taken into consideration as well)
I had attach the picture for your reference. Thanks a lot in advance!
Best Regards,
QianNing
I have created Straight Table
Dimension is MachineNo
Expression is 1
For Dimension I've applied BG color and Text color as
BG Color =If(Result='Failed', Red())
and
Text Color =If(Result='Failed', White())
Pre Requisites
1) Remove the Caption
2) Under Presentation - I did Hide Column for expression
3) Under Style - Cell Border Transparency should be 100%
Dear Anil,
Thanks a lot for your help! Your solution works perfectly for me.
Best Regards
QianNing
Glad we were able to dispense something useful. But, There is one drawback if we filter on Straight table to get associative it is changing as per lieu and over reading. So, I would think much response like
BG Color =If(Result='Failed', If(Variable = 1, White(), Red()))
and
Text Color =If(Result='Failed', If(Variable = 1, Black(), White()))