topic SV:Re: Set analysis - show only last 12 weeks data in QlikView

Set analysis - show only last 12 weeks data

Wed, 13 Jan 2010 14:34:23 GMT

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)

Set analysis - show only last 12 weeks data

Wed, 13 Jan 2010 15:10:28 GMT

Hi Max,

see the attached example.

Good luck!

Rainer

SV:Re: Set analysis - show only last 12 weeks data

Wed, 13 Jan 2010 15:24:20 GMT

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)