topic Re: How to add nulls values to Others using set analysis. in App Development https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436501#M34545 <HTML><HEAD></HEAD><BODY><P>do you have access to load script?</P></BODY></HTML> Wed, 08 Nov 2017 10:16:28 GMT shraddha_g 2017-11-08T10:16:28Z How to add nulls values to Others using set analysis. https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436500#M34544 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P></P><P>I have a dimension called state which contains values like CA, NY, Others, nulls.</P><P></P><P>I have a measure called salse. I want to add all the salse value to Others category while creating a bar chart. </P><P>Can anybody help me to handle this?</P></BODY></HTML> Wed, 08 Nov 2017 10:14:49 GMT https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436500#M34544 Anonymous 2017-11-08T10:14:49Z Re: How to add nulls values to Others using set analysis. https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436501#M34545 <HTML><HEAD></HEAD><BODY><P>do you have access to load script?</P></BODY></HTML> Wed, 08 Nov 2017 10:16:28 GMT https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436501#M34545 shraddha_g 2017-11-08T10:16:28Z Re: How to add nulls values to Others using set analysis. https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436502#M34546 <HTML><HEAD></HEAD><BODY><P>Use the below in your dimension:</P><P>if(state='CA' or <SPAN style="font-size: 13.3333px;">state='NY',Others)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN>Regards<BR />Pratyush</P></BODY></HTML> Wed, 08 Nov 2017 10:16:32 GMT https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436502#M34546 prat1507 2017-11-08T10:16:32Z Re: How to add nulls values to Others using set analysis. https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436503#M34547 <HTML><HEAD></HEAD><BODY><P>no </P></BODY></HTML> Thu, 09 Nov 2017 07:05:50 GMT https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436503#M34547 Anonymous 2017-11-09T07:05:50Z Re: How to add nulls values to Others using set analysis. https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436504#M34548 <HTML><HEAD></HEAD><BODY><P>Thanks <A href="https://community.qlik.com/qlik-users/229859">prat1507</A>&nbsp; it worked this way&nbsp; </P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;"><STRONG>if(</STRONG>isnull<STRONG>(state)</STRONG><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><STRONG>,'Others',state)</STRONG></SPAN></P><P><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333px; font-family: inherit;"><BR /></SPAN></P></BODY></HTML> Thu, 09 Nov 2017 07:07:17 GMT https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436504#M34548 Anonymous 2017-11-09T07:07:17Z Re: How to add nulls values to Others using set analysis. https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436505#M34549 <HTML><HEAD></HEAD><BODY><P>Welcome</P></BODY></HTML> Thu, 09 Nov 2017 07:36:00 GMT https://community.qlik.com/t5/App-Development/How-to-add-nulls-values-to-Others-using-set-analysis/m-p/1436505#M34549 prat1507 2017-11-09T07:36:00Z