combine two columns in bar chart to make one

[#1]

i need to combine null and unknown bars into one in bar chart

=if('ethnicity'='NULL' or 'ethnicity'='Unknown','Unknown)

i tried this but its not working. I dont know if I am putting it in the right place

[maxgro]

maybe with a calculated dim

=if(mixmatch(ethnicity, 'NULL',  'Unknown'), 'Unknown', ethnicity)

[#3]

why dont you assign Unknown text to all null values while loading the script ?

ex: if(len(trim(fieldname))=0,'Unknown',fieldname) as fieldname

or map using ..

[Greg_Williams]

isnull(<field name>) can be used in logic to test for null values.

[Clever_Anjos]

=if('ethnicity'='NULL' or 'ethnicity'='Unknown','Unknown) is comparing string

What´s name of your field?

Posting some data will help.

[Clever_Anjos]

Please check if this solve your problem

[#7]

the field name is Ethnicity. Null and Unknown in the field need to be combined

[Clever_Anjos]

Please check the file I´ve attached

[ashfaq_haseeb]

Hi Vector

Answer is provided here in the below post.

http://community.qlik.com/message/557821#557821

Regards

ASHFAQ