Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

bharatkishore
Contributor 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

Re: Need to show top 10

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 .

12 Replies
Not applicable

Re: Need to show top 10

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

bharatkishore
Contributor III

Re: Need to show top 10

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..

Re: Need to show top 10

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

Re: Need to show top 10

Sorry. Can't see any png.

bharatkishore
Contributor III

Re: Need to show top 10

sorry.. my bad.. now pls check

bharatkishore
Contributor III

Re: Need to show top 10

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

Re: Need to show top 10

Hi Bharat,

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

bharatkishore
Contributor III

Re: Need to show top 10

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.

Re: Need to show top 10

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.

Community Browser