Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
joeybird
Contributor III

show specific dates qlik sense

Hi

I am using qlik sense

I have the following set analysis

SUM({$< WeekCommencingMonday= {"$(='>=' & WeekStart(Max(WeekCommencingMonday),-8) & '<=' & Date(Max(Date), 'DD/MM/YYYY'))"}, ID={'1', '2', '3'}>}Value)

in the data load I have this to work out week commencing

Date(WeekEnd("Date", 0, 1), 'DD/MM/YY') as WeekCommencingMonday

on the chart I am trying to restrict the data to 8 weeks

it shows all the dates going back as far as 2016 along the x axis.. I only want it to show the last 8 weeks

also as well, if there is no data for e.g 01/01/2018, I still want it to show this date along the x axis

I do have an additional calendar script that value data is linked to as well, making sure all dates are in the data load

please help