Qlik Community

Qlik Sense App Development

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

chitraxi
New 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
New Contributor II

Re: How to add nulls values to Others using set analysis.

Thanks prat1507  it worked this way 

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


5 Replies
shraddha_g
Honored Contributor III

Re: How to add nulls values to Others using set analysis.

do you have access to load script?

prat1507
Valued Contributor

Re: How to add nulls values to Others using set analysis.

Use the below in your dimension:

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


Regards
Pratyush

chitraxi
New Contributor II

Re: How to add nulls values to Others using set analysis.

no

chitraxi
New Contributor II

Re: How to add nulls values to Others using set analysis.

Thanks prat1507  it worked this way 

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


prat1507
Valued Contributor

Re: How to add nulls values to Others using set analysis.

Welcome

Community Browser