Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

why dimension limits and rank in qk11?

why dimension limits and rank in qk11?

13 Replies
Not applicable
Author

Hi siva

can you please elaborate your question so that i can rep

jagan
Partner - Champion III
Partner - Champion III

Hi Siva,

If you want to see Top N by a dimension then this comes handy.

Example: Top 5 Customers, Top 5 Products

Regards,

Jagan.

Not applicable
Author

Hi Jani,

We have dimension limits tab is der bit why we have Rank() ?

using dimension limits tab we can get top sales or bottom sales but why we have rank() ?

Not applicable
Author

Hi Jagan,

We have dimension limits tab is der bit why we have Rank() ?

using dimension limits tab we can get top sales or bottom sales but why we have rank() ?

Not applicable
Author

Dimension limit tab is not available everywhere. Moreover, we have Rank() function to use it anywhere we require.

Hope this was helpful.

Thanks,

Singh

Not applicable
Author

This is one of the new enhancement added to Qlikview 11 that you can limit your dimensions using Dimension Limit tab. Since it is an enhancement, the same thing can be done by using rank() or other functions in previous versions as well.

Hope this was helpful.

Thanks,

Singh

ashfaq_haseeb
Champion III
Champion III

Hi,

You cannot apply dimension limit with pivot table then comes rank()

Regards

ASHFAQ

jagan
Partner - Champion III
Partner - Champion III

Hi,

For Pivot Table you don't have this option, Rank() is used over there.

Regards,

Jagan.

Not applicable
Author

we had calculated dimension and express?then y we go for dimension limits ?