Show Top 10

[bharatkishore]

Hi All,

I have an E-mail date, Market , Brand and Email Name fields.

Now Email date has Data till June 30.I need to show data(i.e. June 20-26(Monday to Sunday)) which are having highest 10 campaigns.

Suppose i selected data from Jun 20- Jun 26 and it has only 3 campaigns, now it should go and get the previous week data. Means  it will go for Jun 13 to Jun 19 and fetch the other campaigns.

So like that it should show latest 10 campaigns.

The calculated dimension i have given is

=if(Aggr(If(Rank(sum([Email Sent Date])) <= 10,sum([Email Sent Date])), Email_Brand,Email_Market,[Email Name]),[Email Name]).

Kindly help.

Thanks

Bharat

[mightyqlikers]

hi,

Share some sample data and expected output.

[bharatkishore]

Pls find the attached excel. I have filtered for Jun 20-Jun 26 Which is a week. Now i can see only 3 Email Names. For that Week.

Now pls make filter for Jun 13 - Jun 19 and u will get some more campaigns.

So i need like that top 10 campaings.

Attached excel and qlikview image.

Pls check

[bharatkishore]

Any help pls