topic Need to select a null bar... in QlikView

Need to select a null bar...

markp201 — Wed, 12 Oct 2016 15:13:53 GMT

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 — Wed, 12 Oct 2016 16:35:30 GMT

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

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

rupamjyotidas — Wed, 12 Oct 2016 16:39:00 GMT

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 — Wed, 12 Oct 2016 16:41:59 GMT

In the customer table?

sunny_talwar — Wed, 12 Oct 2016 16:55:29 GMT

Yes whereever you have the certification field in your table