Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

merging two pie chart sections into one

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!

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

Its attached in another post.

Regards

ASHFAQ

View solution in original post

8 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

Can you post your dimensions and expression here.

Or If possible post your sample file here

Regards

ASHFAQ

Not applicable
Author

expressoin.png

ashfaq_haseeb
Champion III
Champion III

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

Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

Hi,

This fixes your first part

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

Working on second post

Regards

ASHFAQ

Not applicable
Author

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

Thanks

ashfaq_haseeb
Champion III
Champion III

Hi,

Its attached in another post.

Regards

ASHFAQ

Not applicable
Author

You can delete it