topic Re: Checkbox not highlighted in QlikView

Checkbox not highlighted

smithaprabhakar — Wed, 20 Dec 2017 08:27:28 GMT

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

Re: Checkbox not highlighted

t_chetirbok — Wed, 20 Dec 2017 08:39:55 GMT

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

Re: Checkbox not highlighted

Anil_Babu_Samineni — Wed, 20 Dec 2017 09:01:08 GMT

can you try Fuzzy search like >0 in search icon from list box?

Re: Checkbox not highlighted

smithaprabhakar — Wed, 20 Dec 2017 10:07:15 GMT

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

Re: Checkbox not highlighted

smithaprabhakar — Wed, 20 Dec 2017 10:29:12 GMT

Hi Anil,

Can you please let me know in detail how we can use the fuzzy search.

Regards

Smitha

Re: Checkbox not highlighted

Anil_Babu_Samineni — Wed, 20 Dec 2017 13:29:19 GMT

Will help you, can you attach QVW to test