Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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!

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: merging two pie chart sections into one

Hi,

Its attached in another post.

Regards

ASHFAQ

View solution in original post

8 Replies
Highlighted

Re: merging two pie chart sections into one

Hi,

Can you post your dimensions and expression here.

Or If possible post your sample file here

Regards

ASHFAQ

Highlighted
Not applicable

Re: merging two pie chart sections into one

expressoin.png

Highlighted

Re: merging two pie chart sections into one

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

Highlighted
Not applicable

Re: merging two pie chart sections into one

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

Highlighted

Re: merging two pie chart sections into one

Hi,

This fixes your first part

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

Working on second post

Regards

ASHFAQ

Highlighted
Not applicable

Re: merging two pie chart sections into one

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

Thanks

Highlighted

Re: merging two pie chart sections into one

Hi,

Its attached in another post.

Regards

ASHFAQ

View solution in original post

Highlighted
Not applicable

Re: merging two pie chart sections into one

You can delete it