Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_chilvers
Specialist
Specialist

Behaviour of Dimension Limits

I have a chart with a dimension limit of 20 values, including an 'others' section.

The behaviour seems strange; the 20th value for Calls is 2, although there are clearly 'other' values larger than 2.

Am I misunderstanding this function?

Any explanation would be helpful.

Thanks

10 Replies
MK_QSL
MVP
MVP

show the screenshot of dimension limit you have used?

Anil_Babu_Samineni

Richard Chilvers wrote:

I have a chart with a dimension limit of 20 values, including an 'others' section.

The behaviour seems strange; the 20th value for Calls is 2, although there are clearly 'other' values larger than 2.

Am I misunderstanding this function?

Where is the function, What you have written

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
richard_chilvers
Specialist
Specialist
Author

Its in the attachment.

MK_QSL
MVP
MVP

I asked for dimension limit tab.. not the result table..

richard_chilvers
Specialist
Specialist
Author

Here is the Dimension Limits tab.

MK_QSL
MVP
MVP

You have selected largest 21 and you are getting 22+... Can you provide your sample app here?

richard_chilvers
Specialist
Specialist
Author

Hi

Yes, the largest 21 seem correct, but entries 22 and 23 should appear in 'Others'.

stigchel
Partner - Master
Partner - Master

Is your Dialed number dimension by any change a dual field with a text and number value? If so, it seems that qv is using the number value to determine the largest values, but is grouping the others by label.

richard_chilvers
Specialist
Specialist
Author

I believe I have found an answer, and I am documenting it here in case its valuable to others.

The chart (in my original attachment) shows the top (21) entries for column 1. However, should column1 have 2 entries in column2, these will be shown separately and therefore it seems that there are 21+ top entries.

As an example, see Dialled Number 08000355123 in my sample.