Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to visualize top contents

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
Highlighted
Specialist III
Specialist III

Re: How to visualize top contents

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: How to visualize top contents

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

Highlighted
Creator
Creator

Re: How to visualize top contents

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,

Highlighted
Creator
Creator

Re: How to visualize top contents

Thank you very much Rob.

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

Regards,

Highlighted
Creator
Creator

Re: How to visualize top contents

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 !

Highlighted
Creator
Creator

Re: How to visualize top contents

This is what i get :

result.PNG

Anyway thank you for your help !

Highlighted
Specialist III
Specialist III

Re: How to visualize top contents

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: How to visualize top contents

Oblique labels on data points is not possible.

-Rob

Highlighted
Creator
Creator

Re: How to visualize top contents

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 !