Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.