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.

[sergio0592]

Hi,

I can't open your .qvw because i'am in PE but i have tried to make a liitle sample reproducing your issue.

I think dual() function can be useful in your case. In my exemple, i display Date and Rubrique only for the two days with the most important visitors number (04/04 and 11/04).

[rwunderlich · Accepted solution]

This example contains some additional ideas about annotating charts including using Dual() as sergio0592‌ mentioned.

Qlikview Cookbook: Tutorial - Annotating Chart Data Points http://qlikviewcookbook.com/recipes/download-info/tutorial-annotating-chart-data-points/

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[marieclaire]

Thank you Jean-Baptiste for your help.

I tried your expression as following :

dual(if(rank(TOTAL Sum(TOP_Visitors)) <=2, TOP_Title&chr(10)&TOP_Date)&chr(10)&num(Sum(TOP_Visitors),'# ##0'), Sum(AUD_Visitors))

It does not work. Perhaps i did not use the right metrics ?

Regards,

[marieclaire]

Thank you very much Rob.

I am going to study this example which seems very well done and explained.

Regards,

[marieclaire]

Hi Rob,

Thanks a lot !

I get this line chart using the expression

=concat(replace(TOP_Title&TOP_Visitors,' ',chr(10)),','&chr(10))

It is a good beginning, not far from the purpose :

I do not manage to keep only the 5 highest labels (max TOP_visitors, rank, aggr ) ?

And is it possible to rotate them to get oblique labels ? It would be easier to read.

Thanks !

[marieclaire]

This is what i get :

Anyway thank you for your help !

[sergio0592]

Hi, see the app in the attached file. But i can't understand why for the second top value, i can't fetch title.

[rwunderlich]

Oblique labels on data points is not possible.

-Rob

[marieclaire]

Hi Jean-Baptiste,

As  oblique labels on data points, is not possible, i will mix your solution with Rob's one.

Thanks a lot for your help !