Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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.