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: 
Shriram_Sridhar
Partner - Contributor III
Partner - Contributor III

Qlikview Dimesion limitation problem

Hi Team,

I'm facing a problem regarding dimension limitation. I tried creating a straight table to display only bottom 5 results( Least sold products). When I tried to set the limitation value as 5 but, Qlik shows only 2 rows instead of 5. When I tried to increase the limitation number to 9, It shows 5. But, Once again face problem when I tried changing the dates. When I change date, The number of rows listed either increases or decreases.

Please let me know how to fix this issue.

3 Replies
MindaugasBacius
Partner - Specialist III
Partner - Specialist III

Usually the misleading number of rows appears when Show Others is enabled:

Screenshot_1.jpg

Could you please share the sample of your qvw?

Shriram_Sridhar
Partner - Contributor III
Partner - Contributor III
Author

No, We have disabled show others also.

dinuwanbr
Creator III
Creator III

Hi,

Can you upload a sample?

Otherwise please check on your dimensions. Try to use aggr() function to the same dimension you are using to limit.

Rgds,

Dinu'1