Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marieclaire
Creator
Creator

How to visualize top contents

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

Extract_top_content.PNG

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

Thank you for your help.

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

11 Replies
sergio0592
Specialist III
Specialist III

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator
Creator
Author

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
Creator
Creator
Author

Thank you very much Rob.

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

Regards,

marieclaire
Creator
Creator
Author

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 :

oblique_labels.PNG


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
Creator
Creator
Author

This is what i get :

result.PNG

Anyway thank you for your help !

sergio0592
Specialist III
Specialist III

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
Partner Ambassador/MVP
Partner Ambassador/MVP

Oblique labels on data points is not possible.

-Rob

marieclaire
Creator
Creator
Author

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 !