Solved: Re: Week 52 in Jan - Qlik Community

Report Inappropriate Content · ‎2017-02-22

Dear All,

I have a cyclic group year/month/day in a chart and with the current calendar setting 1 Jan 2017 falls into week 52. My issue is when filtering data for Jan it shows week 52 as well. How can I just show week 52 in Dec 20166 and not in Jan2017 please?

Thanks

Neda

adamdavi3s · ‎2017-02-22

Hi Neda,

Just apply a similar logic when you generate your master calendar

So something like

=if(month(OrderDate)=1 and week(OrderDate)=52,0, 1) as weekcheckflag

However you'll still need to alter your expressions:

sum({<weekcheckflag={'1'}>} value)

Or select the flag as a default.

Just as a random aside, can I suggest keeping all expressions in variables and then the definitions of those variables in a file, this way it makes life a lot easier when you need to make this sort of change

View solution in original post

sasikanth · ‎2017-02-22

HI,

because Month field Might be calculated based on date field and when you select Month 'JAN' all dates should be selected related to JAN month.(including Jan 1st fell in 52 nd week)

if you select Year(2017) then it will show only 5 weeks

Try to suppress Zero values in Properties-->Presentation . also suppress null values in dimension.

Report Inappropriate Content · ‎2017-02-22

Hi Sasi,

Thanks for your reply. I do have values for 1st jan since supress zero wouldn't work. is there anyway when selecting weekly view week 52 wouldn't appear in Jan data?

sasikanth · ‎2017-02-22

hi,

select both MONTH and YEAR so that only 2017 related weeks will be displayed .

adamdavi3s · ‎2017-02-22

Master calendar and flags will be the simplest way to do this I imagine

adamdavi3s · ‎2017-02-22

The simplest way with a straight up formula is something like:

=if(month(OrderDate)=1 and week(OrderDate)=52,0, sum(HoursWorked))

Regular formula:

if formula:

nitin_01 · ‎2017-02-22

Hope this works out for you

Redefining the Week Numbers‌

Regards,

Nitin.

Report Inappropriate Content · ‎2017-02-22

Hi Adam,

Thanks for this. I do have Master calendar in my dashboard but not sure how to get this fixed in master calendar?

the above solution would work but I'd have to change many expressions(50!) this way so prefer to fix it in master calendar if possible.

Thanks

Neda

Report Inappropriate Content · ‎2017-02-22

Thanks Nitin, I am happy with week numbers as it is but just need to not showing week 52 in Jan chart.

sasikanth · ‎2017-02-22

Would you be able to share your app?