Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
chitraxi
Contributor II
Contributor II

How to add nulls values to Others using set analysis.

Hi all,

I have a dimension called state which contains values like CA, NY, Others, nulls.

I have a measure called salse. I want to add all the salse value to Others category while creating a bar chart.

Can anybody help me to handle this?

1 Solution

Accepted Solutions
chitraxi
Contributor II
Contributor II
Author

Thanks prat1507  it worked this way 

if(isnull(state),'Others',state)


View solution in original post

5 Replies
shraddha_g
Partner
Partner

do you have access to load script?

prat1507
Specialist
Specialist

Use the below in your dimension:

if(state='CA' or state='NY',Others)


Regards
Pratyush

chitraxi
Contributor II
Contributor II
Author

no

chitraxi
Contributor II
Contributor II
Author

Thanks prat1507  it worked this way 

if(isnull(state),'Others',state)


prat1507
Specialist
Specialist

Welcome