How to visualize top contents

[marieclaire]

Hi the community,

I need to visualize the audience of several websites.

I have 2 tables :

audience:

LOAD

    SITE as CLE_site,

     DATE as AUD_Date,

     VISITORS as AUD_Visitors

topContents:

LOAD

     SITE as CLE_site,

     DATE as TOP_Date,

     TITLE as TOP_Title,

     VISITORS as TOP_Visitors

For each site, i need to show the daily audience, and among the highest values, i have to show the titles of the best contents.

For each content, i have to remind the date, and the number of visitors.

I try to get something like that ( i knew to display the 5 or 6 contents wich are higher than the daily average).:

Do you thing it is possible to do that with qlikview ?

Thank you for your help.

[Frank_Hartmann]

Also the second sum is not correct. try this:

dual(if(rank (TOTAL  aggr(Sum(TOP_Visitors),TOP_Title))<=2,TOP_Date&chr(10)&only(TOP_Title)&chr(10)&aggr(Sum(TOP_Visitors),TOP_Title),''),aggr(Sum(TOP_Visitors),TOP_Title))

[marieclaire]

Hello Franck,

Thank you for your intervention.

I try to represent the global audience curve, and on 4 or 5 peaks, the title of the contents concerned.

for the moment, the solution that comes closest to my need is based on 2 expressions :

=sum(AUD_Visitors)

=Aggr(if(rank(sum(TOP_Visitors))<=4,@CLE_Date&chr(10)&only(TOP_Title)&chr(10)),TOP_Title)

In your example, the line chart is based on TOP_Visitors.

I still have to fix an issue : the above expression does not always display dates on data points.

Any idea ?

Thank you