Date selection question

Thu, 27 Jun 2013 22:52:28 GMT

Hello, I have an autogenerated master-calendar for last 4 year which includes: year,quarter,month and week.

Can you please help me, I couldn't found a solution to:

select from a listbox a week and the result of my selection to be weeks from [Week selected-12;Week selected].

Is it possible?

Re: Date selection question

Gysbert_Wassenaar — Fri, 28 Jun 2013 18:53:35 GMT

Yes, but it's not clear to me what you want. Do you want to change the selection in the Week field or do you want the result of an expression to be based on the last 13 weeks leading up to the selected week?

For the first option you need to add a Select in Field action to the OnSelect field trigger of the Week field. The search string would be something like: ='>=$(=only(Week)-12)<=$(=only(Week))'

For the second option you'd add a set modifier to your expression. For example sum(Sales) would become sum({<Week={'>=$(=only(Week)-12)<=$(=only(Week))'}>}Sales)

If you need more help read this document: Preparing examples for Upload - Reduction and Data Scrambling

topic Date selection question in QlikView

Date selection question

Re: Date selection question