Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
berryandcherry6
Creator II
Creator 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.

0 Replies