topic Re: Show Top 10 in QlikView

Show Top 10

bharatkishore — Fri, 08 Jul 2016 10:36:40 GMT

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

Re: Show Top 10

mightyqlikers — Fri, 08 Jul 2016 10:44:05 GMT

hi,

Share some sample data and expected output.

Re: Show Top 10

bharatkishore — Fri, 08 Jul 2016 10:50:32 GMT

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

Re: Show Top 10

bharatkishore — Fri, 08 Jul 2016 11:32:04 GMT

Any help pls