This content has been marked as final. Show 4 replies
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?