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%
Not really, What you are talking about. Perhaps this?
If(Match(OM, 'O'), BCNo)
if it is just "O" you can go with anil suggestion and if u want any word which contain "O" ,then the corresponding value should be included you should use
If(WildMatch(OM, '*O*'), BCNo)
Dear Anil,
Thanks for your prompt reply. I was wondering is it possible for us to achieve the similar outcome like the format in the picture below? Which means after user have made the selection and filter the data, it was able to highlight the 'BCNo' field content if 'OM' field contains 'O'.
Best Regards,
QianNing
Possible, have a look
Dear Anil,
Sorry for misleading you. I think I didn't explain my requirement properly. I had created a sample of QVW for your reference. Your solution is able to fulfill half of my goal. However, when user makes a selection (For example when choose a specific date), the list box didn't highlight the data and show the corresponding content.
In this case, if user select on 23/12/17, I want the list box to highlight Machine206 as this is the only machine that has failed in result.
I had attached the QVW below, any ideas would be greatly appreciated! Thanks!
(If there are any alternative ways to show/Highlight the MachineNo when detected a 'failed' in the result after user made the selection in date field, please advice me as well)
Best Regards
QianNing
Dear Pradosh,
Sorry for misleading you. I think I didn't explain my requirement properly. I had created a sample of QVW for your reference. Your solution is able to fulfill half of my goal. However, when user makes a selection (For example when choose a specific date), the list box didn't highlight the data and show the corresponding content.
In this case, if user select on 23/12/17, I want the list box to highlight Machine206 as this is the only machine that has failed in result.
I had attached the QVW below, any ideas would be greatly appreciated! Thanks!
(If there are any alternative ways to show/Highlight the MachineNo when detected a 'failed' in the result after user made the selection in date field, please advice me as well)
Best Regards
QianNing
PFA
Nice workaround Anil..
Dear Anil,
As I was using Qlikview Personal Edition, so I was unable to open your Qlikview File. Are you able to guide me on what you did in the Qlikview File? (Perhaps a screen shot or some steps procedure?) Thanks a lot in advance!
Best Regards
QianNing