Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

See why BI users voted Qlik #1 in 11 categories. GET REPORT
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

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


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 :


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.

0 Replies