Need to select a null bar...

[markp201]

We have our vendors whom we require to be certified and there 3 types of certifications.

We created a bar chart with count of vendors by certification type and there is a 4th "null" bar (vendors who have not been certified)

Qlikview will not allow selection of this bar.

[sunny_talwar]

May be make the null into a non-null value in script

LOAD If(Len(Trim(certification)) = 0, 'NullCell', certification) as certification

[rupamjyotidas]

You need to make changes in the Script:

If(Len(Trim(certification)) <1 or ISNULL(certification), 'BLANK', certification) as certification

Then you will have 'BLANK' in your list box, which you can select

[markp201]

In the customer table?

[sunny_talwar]

Yes whereever you have the certification field in your table