topic How to include Null Values in 'Others' rather than excluding them in qlik sense. in App Development

How to include Null Values in 'Others' rather than excluding them in qlik sense.

Anonymous — Sat, 16 Nov 2024 09:07:25 GMT

I want to show a pie chart with top 5 countries by sales. I have some null Values and unknown in countries which i want them to be a part of my calculation.But in some cases Nulls and unknowns also comes in my top 5 apart from others. I want those nulls and Unknown to be in calculations but these nulls and unknowns should be included in Others. How can i do it in qlik sense.

Re: How to include Null Values in 'Others' rather than excluding them in qlik sense.

sunny_talwar — Sun, 29 Oct 2017 21:14:54 GMT

I suggest using a calculated dimension instead of using the inbuilt

Re: How to include Null Values in 'Others' rather than excluding them in qlik sense.

Anonymous — Mon, 30 Oct 2017 08:30:37 GMT

Hi sunny,thanks for the answer . This works but what do i do for Unknown?? Will

Country={"*"},Country-={'Unknown'} work??

I am asking this because this formula doesnt work with my desktop version but it works for server i dont know why may be because of version issue.

Re: How to include Null Values in 'Others' rather than excluding them in qlik sense.

kaushiknsolanki — Mon, 30 Oct 2017 08:34:59 GMT

Hi,

I would suggest you to give null and unknown a name in load script to ease the expression on charts. Like below.

Load *,If(Isnull(Country) or Country = 'Unknown','Others',Country) as NewCountry

From xyz;

Now use this new field as your dimension.

Regards,

Kaushik Solanki

Re: How to include Null Values in 'Others' rather than excluding them in qlik sense.

sunny_talwar — Mon, 30 Oct 2017 08:35:06 GMT

May be this

Country={"*"}-{'Unknown'}