Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Need to show top 10

Hi All,

I have a query regarding to show top 10.

I have a market and brand filters and dimension i took as campaign. i have field called email sent date. Now my query is i need to show top 10 records means last 10 records based on the market and brand selection.

If i don't select any market and brand filters also i need to defautly top 10 records.

I have attached qvw and the necessary excel file. Please have a look and kindly needed your help.

Thanks,

Bharat

6 Replies
Anil_Babu_Samineni

You want to show Top 10 / Last 10 Records?

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)
bharatkishore
Creator III
Creator III
Author

Last 10 records...only 10

Anil_Babu_Samineni

How about Dimension Limits tab?

Capture.PNG

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)
HirisH_V7
Master
Master

Hi ,

look into this,

http://www.learnqlickview.com/a-qlikview-tip-how-to-display-top-n-and-bottom-n-values/

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
bharatkishore
Creator III
Creator III
Author

No i should use dimension limits because i have 5 expressions..

bharatkishore
Creator III
Creator III
Author

i have formula also which i need to write..