topic Re: How to do default selection in week in QlikView

How to do default selection in week

Wed, 01 Oct 2014 13:46:43 GMT

Hello Everyone,

I have below scenario,

i am showing some values in table, when dashboard opens the table should show past 13 weeks values from this week.

if user selects particular week it should show past 13 weeks values

Please help me in that

Thanks

Anonymous — Wed, 01 Oct 2014 13:55:01 GMT

supose you have a field myweek you should use set analysis

e.g. sum({<myweek={>=$(=selectedweek-13)}<=$(=selectedweek))'>}sumvalue)

example with week today

sum({<myweek={'>=$(week(today()-13))>=$(=week(today())'}>}