Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Need to show top 10

Hi All,

I need to show top 10 records based on the Email Sent Date.

I have given the calculated dimension like this..

=if(Aggr(If(Rank(sum([Email Sent Date])) <= 6,sum([Email Sent Date])), Email_Market,Email_Brand,[Email Subject Line])

,[Email Subject Line])

But it is not fetching the latest(or) last 10 records.

Kindly suggest.

Thanks,

Bharat

1 Solution

Accepted Solutions
tamilarasu

I have attached the updated file below.  Try by yourself in searching google, you will gain more knowledge. this will also help you to remember the scenarios in future. Good luck .

View solution in original post

12 Replies
Not applicable

Did you mean to use Count and also say <=10?

bharatkishore
Creator III
Creator III
Author

Hi RamKumar

Please find the attached image. On how i need to get.. I am not getting latest dates.Is there anything i am doing wrong..

tamilarasu

Not sure what you're trying to achieve. You can not sum the date field. Could you post a sample and expected output.?

Not applicable

Sorry. Can't see any png.

bharatkishore
Creator III
Creator III
Author

sorry.. my bad.. now pls check

bharatkishore
Creator III
Creator III
Author

Hi Nagaraj,

Pls find the attached qvw and for the market i selected Italy and Brand i selected as Fiat..Now in the e-mailsent date u can see that it starts from 6/17/2016.. Based on that i need to last 6 records.. i.e. from the names from emailsubjectline should come from 6/17/2016 to 5/5/2016.

Pls let me know if you need anything more

tamilarasu

Hi Bharat,

In this case you can use either Dimension limit option or expression. Have a look at the attachament.

bharatkishore
Creator III
Creator III
Author

Thanks a lot Nagaraj.. My requirement is almost completed.

Now i have one more problem i.e. i need calculate the average of 6 records and i need to display in as image..

Pls find the attached excel on how i need to calculate the formula.

If the value is >10% means then green color and <10%means red and else yellow color.

If this is done my requirement is  completed.Kindly help.

tamilarasu

I am not able understand the average concept. Could you explain here.?

Note: I have modified the expression in above attachment. Please use updated one.