0 Replies Latest reply: May 25, 2016 12:40 PM by Roberto guerra RSS

    Followers Evolution - Help!

    Roberto guerra

      Dear Community! I'm having trouble seeing growth in the Facebook Pages i'm monitoring. Everything works fine... but when I want to see how many followers a page has, it only shows me the MAX. What the script does, is that it asks for the value and joins the data with another file.

      Can somebody help me with this?

       

      The fields i need to talk with each other are Page_FBFeed, FECHA_FBFEED, and Page_Likes.

      This is my load script (when loading data from the file with the info):

       

      Thanks in advanced!!!!

      Base_Facebook:

      LOAD

      RowNo() as id,

      Feed_id as id_FBFeed,

      subfield(filename(),'_',1) as Marca_FBFeed,

           subfield(filename(),'_',3) as Cliente_FBFeed,

           //subfield(filename(),'_',5) as Page_FBFeed,

           Feed_from_id as from_id_FBFeed,

           Feed_caption as caption_FBFeed,

           Feed_created_time as created_time_FBFeed,

           Feed_created_time_qvdatetime as created_time_qvdatetime_FBFeed,

           Feed_created_time_qvdate as created_time_qvdate_FBFeed,

           Feed_created_time_qvtime as created_time_qvtime_FBFeed,

           Feed_description as description_FBFeed,

           Feed_from_name as from_name_FBFeed,

           Feed_link as link_FBFeed,

           Feed_message as message_FBFeed,

           Feed_name as name_FBFeed,

           Feed_object_id as object_id_FBFeed,

           Feed_picture as picture_FBFeed,

           Feed_shares as shares_FBFeed,

           Feed_status_type as status_type_FBFeed,

           Feed_to_id as to_id_FBFeed,

           Feed_to_name as to_name_FBFeed,

           Feed_type as type_FBFeed,

           makedate(left(Feed_created_time,4),mid(Feed_created_time,6,2),MID(Feed_created_time,9,2)) as FECHA_FBFEED,

           makedate(left(Feed_created_time,4),mid(Feed_created_time,6,2),MID(Feed_created_time,9,2)) as Fecha_Follow,

           mid(Feed_created_time,12,2) as HORA_FBFEED,

           Feed_updated_time as updated_time_FBFeed,

           Feed_updated_time_qvdatetime as updated_time_qvdatetime_FBFeed,

           Feed_updated_time_qvdate as updated_time_qvdate_FBFeed,

           Feed_updated_time_qvtime as updated_time_qvtime_FBFeed,

           Feed_total_likes as total_likes_FBFeed,

           Page_status,

           Page_id as Page_FBFeed,

           Page_about,

           Page_category,

           Page_company_overview,

           Page_description,

           Page_founded,

           Page_general_info,

           Page_link,

           Page_mission,

           Page_name,

           Page_products,

           Page_username,

           Page_website,

           Page_likes,

           Page_picture_url,

           Feed_total_comments as total_comments_FBFeed

      FROM

      [C:\qlikview\Redes Sociales\QVD\FACEBOOK\*_Why_*.QVD]

      (qvd);

      Bas1e_Facebook:LOADRowNo() as id,Feed_id as id_FBFeed, //page,//if(Feed_from_id = '', 'Marca', 'Usuarios') as is_self_posted_FBFeed, subfield(filename(),'_',1) as Marca_FBFeed,     subfield(filename(),'_',3) as Cliente_FBFeed,     //subfield(filename(),'_',5) as Page_FBFeed,     Feed_from_id as from_id_FBFeed,      Feed_caption as caption_FBFeed,      Feed_created_time as created_time_FBFeed,      Feed_created_time_qvdatetime as created_time_qvdatetime_FBFeed,      Feed_created_time_qvdate as created_time_qvdate_FBFeed,      Feed_created_time_qvtime as created_time_qvtime_FBFeed,      Feed_description as description_FBFeed,      Feed_from_name as from_name_FBFeed,      Feed_link as link_FBFeed,      Feed_message as message_FBFeed,      Feed_name as name_FBFeed,      Feed_object_id as object_id_FBFeed,      Feed_picture as picture_FBFeed,      Feed_shares as shares_FBFeed,      Feed_status_type as status_type_FBFeed,      Feed_to_id as to_id_FBFeed,      Feed_to_name as to_name_FBFeed,      Feed_type as type_FBFeed,      makedate(left(Feed_created_time,4),mid(Feed_created_time,6,2),MID(Feed_created_time,9,2)) as FECHA_FBFEED,     makedate(left(Feed_created_time,4),mid(Feed_created_time,6,2),MID(Feed_created_time,9,2)) as Fecha_Follow,     mid(Feed_created_time,12,2) as HORA_FBFEED,     Feed_updated_time as updated_time_FBFeed,      Feed_updated_time_qvdatetime as updated_time_qvdatetime_FBFeed,      Feed_updated_time_qvdate as updated_time_qvdate_FBFeed,      Feed_updated_time_qvtime as updated_time_qvtime_FBFeed,      Feed_total_likes as total_likes_FBFeed,      Page_status,      Page_id as Page_FBFeed,      Page_about,      Page_category,      Page_company_overview,      Page_description,      Page_founded,      Page_general_info,      Page_link,      Page_mission,      Page_name,      Page_products,      Page_username,      Page_website,      Page_likes,      Page_picture_url,     Feed_total_comments as total_comments_FBFeedFROM[C:\qlikview\Redes Sociales\QVD\FACEBOOK\*_Why_*.QVD](q