Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Need to show only last 8 Weekstart- Weekend in line graph

Hi,

i have a line graph, where i  want to display data in graph for only last 8 weeks.

Here i have Dimension :    Week_Group_Year

date(WeekStart(CanonicalDate), 'MM-DD-YYYY') &' - '& date(WeekEnd(CanonicalDate), 'MM-DD-YYYY')  as Week_Group_Year,  

Expression :

Count({$<DateType={signed},user_signed={1},

CanonicalDate = {"<=$(=WeekEnd(today(),-1))"}>}invitation_id)

But when i give fixed number in properties of dimension to 8. It shows more than last 8 weeks weekend and Weekstart datas.

How to fix it to show only to last 8 weeks.

i have attached qvf file, please refer it

Please help me.

Tags (1)