Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

Script last 6 weeks

Hello ,

I want to show last 6 weeks values in my graph

My date dimension is =day(weekstart(Created))&'-' & day(weekend(Created)) &' ' & monthname(Created)

and my expression is =count(ID)

Thanks

Labels (1)
4 Replies
QSense
Creator II
Creator II
Author

My date field (created) format is : dd.mm.yyyy hh:ss

QSense
Creator II
Creator II
Author

it didnt work

Not applicable

use smth like count({< Date = {'>=$(=date(weekstart(Created)))<=$(=date(weekend(Created)))'}>}ID)

QSense
Creator II
Creator II
Author

It gives all weeks