Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be make the null into a non-null value in script
LOAD If(Len(Trim(certification)) = 0, 'NullCell', certification) as certification
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
In the customer table?
Yes whereever you have the certification field in your table