merging two pie chart sections into one

[#1]

I have a Null section and a unknown section. I want to merge them together. I am new to Qlikview expressions so if that is the problem please explain thoroughly. THANKS!

[ashfaq_haseeb]

Hi,

Can you post your dimensions and expression here.

Or If possible post your sample file here

Regards

ASHFAQ

[#3]

[ashfaq_haseeb]

Hi

add below calculated dimension instead of your dimension

=If(Isnull([Dimension Field]).or [Dimension Field]='Unknown' or [Dimension Field]='Null','New Selection', [Dimension Field])

Regards

ASHFAQ

[#5]

this combined all the sections. I want to only combine null and unknown.

[ashfaq_haseeb]

Hi,

This fixes your first part

=IF(Ethnicity='NULL' or Ethnicity='Unknown','New Group',Ethnicity)

Working on second post

Regards

ASHFAQ

[#7]

can you send me the file with the fixed issues its still not working.

Thanks

[ashfaq_haseeb · Accepted solution]

Hi,

Its attached in another post.

Regards

ASHFAQ

[#9]

You can delete it