Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set analysis - show only last 12 weeks data

Hi!

I'm a newbie to Set analysis but is finding it very hepful, specially when designing dashboards where I don't want the users to make selections.

I want one of my charts in the dashboard to only show the trends for the last 12 weeks. But my set expression doesn't seem to work for me.. I need some of your expert help 🙂

My date format in the application is YYYYMMDD as you see below. This expression gives back current selections instead of giving only dates larger than the start of week twelve weeks ago.

Cheers,

Max

sum

( {$< Date = {">=$(=date(#weekstart(Today(),-12),'YYYYMMDD'))"} >} StdTime)



1 Solution

Accepted Solutions
Not applicable

Hi Max,

see the attached example.

Good luck!

Rainer

View solution in original post

2 Replies
Not applicable

Hi Max,

see the attached example.

Good luck!

Rainer

View solution in original post

Not applicable

Thanks for the quick answer, Rainer. Much appreciated!

Max week in the application isn't current week, unfortunately.. Otherwise it would have been what I wanted!

I did a couple of tests again and without the "#" it looks like it's working! Maybe I was a bit quick to consult the forum 😛

sum

( {$ < Date = {">=$(=date(weekstart(Today(),-12),'YYYYMMDD'))"} > } StdTime)