Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
When we select the checkbox (Fortune 1000) we able to filter the data but the checkbox is not highlighted.
We have used below different expression in list box field in order to highlight the checkbox but no luck.
=if(len(F1000_RANK)>0,'Fortune 1000')
=if(dual('Q',F1000_RANK)<>' ','Fortune 1000')
=if(F1000_RANK<>' ','Fortune 1000')
Request to reply back ASAP.
Regards,
Smitha
Hi Smitha,
when you click on the Fortune 1000 what should be selected?
As I understand everything that is not empty in F1000_RANK. So, why 831 is not selected on your picture
can you try Fuzzy search like >0 in search icon from list box?
Hi,
When i click on Fortune 1000 checkbox the checkbox is not selected but the data associated with F1000_RANK field is selected.
831 is not selected because there are some more filters hence the data not associated is greyed out.
Also observed, when we are checking the condition for null values the checkbox is not highlighted but if we validate the condition for string value it will work fine with selection enable.
Null validations:
=if(len(F1000_RANK)>0,'Fortune 1000')
=if(dual('Q',F1000_RANK)<>' ','Fortune 1000')
=if(F1000_RANK<>' ','Fortune 1000')
String Validation:
if(column1='Y','Fortune 1000')
Regards
Smitha
Hi Anil,
Can you please let me know in detail how we can use the fuzzy search.
Regards
Smitha
Will help you, can you attach QVW to test