4 Replies Latest reply: Dec 2, 2017 6:28 AM by omar bensalem RSS

    Weeks With No Values

    Kenneth Holden

      Hello my fellow community users, I have a dashboard which I am showing last year‘s performance versus this year‘s performance and some of my sales representatives do not have any sales last year or this year in a particular week

      This is a fiscal week by fiscal we comparison

      Qliksense therefore only shows the weeks in which the sales reps in which they  had business and if there was five weeks in the month it only shows business for example for three

      If Then gives the weekly average difference divided by three weeks versus by five so it excludes the empty weeks

      The question is, is there a way in a column chart to tell qliksense not to ignore the empty weeks between two years?