Display one field's content based on another field's content

[s10157754]

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

[Anil_Babu_Samineni · Accepted solution]

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%

[s10157754]

‌Dear Anil,

Thanks a lot for your help! Your solution works perfectly for me.

Best Regards

QianNing

[Anil_Babu_Samineni]

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()))