Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks
Have u created your own calendar?
if so, use the week dimension of ur calendar: under adds-on (chart proerties); keep "show null values" checked
Unfortunately I’m using a number 1234 which was assigned into the source file versus an actual calendar date
So the option of using the calendar function is not available
Is there a way to tell it’s to put a zero if there’s no activity in those weeks
Maybe:
if( aggr(sum(Measure),week)=0,0,sum(Measure)
or sthing like
if(aggr( len(trim(Measure)),week)=0,0,sum(Measure))
and keep show null values check
It depends on how the null values are specified in your source ? a blank, a '-' etc; do an if condition as I've showed on this; and you'll be good