Qlikview Dimesion limitation problem

[Shriram_Sridhar]

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.

[MindaugasBacius]

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

Could you please share the sample of your qvw?

[Shriram_Sridhar]

No, We have disabled show others also.

[dinuwanbr]

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