topic To Display week based on selection in QlikView

To Display week based on selection

ajsjoshua — Sat, 16 Nov 2024 05:07:02 GMT

Dear all,

I am showing sales value for weeks for ex:Week32 Oct 29 to Nov 04.If an user selects month for ex:nov then it will show only sales value for the month november but my week displays like Week32 Oct 29 to Nov 04.i want to show like Week32 Nov 01 to Nov 04.I am using fiscal calendar and my week starts from Monday to Sunday.

My calculated dimension:

FiscalWeek &' '&date(WeekStart(CDate),'MMM DD')&' to '&date(WeekEnd(CDate),'MMM DD')

Regards,

Joshua.

Re: To Display week based on selection

sunny_talwar — Wed, 28 Nov 2018 12:50:09 GMT

May be try this

FiscalWeek &' '& Date(RangeMax(WeekStart(CDate), Min(CDate)), 'MMM DD') & ' to ' & Date(RangeMin(WeekEnd(CDate), Max(CDate)), 'MMM DD')

Re: To Display week based on selection

ajsjoshua — Wed, 28 Nov 2018 12:54:32 GMT

Dear brother,

=FiscalWeek &' '& Date(RangeMax(WeekStart(CDate), Min(CDate)), 'MMM DD') & ' to ' & Date(RangeMin(WeekEnd(CDate), Max(CDate)), 'MMM DD')

I am getting error in calculated dimension.

Re: To Display week based on selection

sunny_talwar — Wed, 28 Nov 2018 12:56:13 GMT

My bad... try this

=FiscalWeek &' '& Date(RangeMax(WeekStart(CDate), Min(TOTAL CDate)), 'MMM DD') & ' to ' & Date(RangeMin(WeekEnd(CDate), Max(TOTAL CDate)), 'MMM DD')