Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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.

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

I suggest using a calculated dimension instead of using the inbuilt

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

I suggest using a calculated dimension instead of using the inbuilt

Capture.PNG

Anonymous
Not applicable
Author

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.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sunny_talwar

May be this

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