Weeks With No Values

[Anonymous]

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 

[OmarBenSalem]

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

[Anonymous]

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

[OmarBenSalem]

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

[OmarBenSalem]

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