Need to show top 10

[bharatkishore]

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

[Anil_Babu_Samineni]

You want to show Top 10 / Last 10 Records?

[bharatkishore]

Last 10 records...only 10

[Anil_Babu_Samineni]

How about Dimension Limits tab?

[HirisH_V7]

Hi ,

look into this,

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

-Hirish

[bharatkishore]

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

[bharatkishore]

i have formula also which i need to write..