By default Rolling 12 months

[#1]

I my application  there is requirement that i have to rolling 12 months from current month of the year by defualt, i.e when we open application the data for rolling 12 months should be displayed and otherwise data for the period selected in the list box should be displayed.........

So can we get some idea on this...?

i have tried some thing in trigger section but no success.......

[jjfabian]

Triggers are the right place to look.

Have you tried making an on open document trigger with a select in field in your month field with month(today())+n as search string?

But beware that this will give you a numerical value back!

Example & Best Practice:

Today is 29.06.2012 so month(today()) wil give you a '7'. This may or may not work as serach string, depending on how your month field looks. As a best practice I always try to have numerical months available in my data model, so that numerical functions like the one above can be used.

Regards,

Jakob

[#3]

Thank for the reply, but It’s not working……..

[jjfabian]

Well, ...

what specific triggers did you add?

and

what format does your month field have?

[#5]

I have applied month(date#(today(),-12)

[jjfabian]

That expression is not going to work.

If you're having trouble writing the expressions, I suggest "testing" them in a text object first

=month(today())-1 is the correct syntax

[#7]

Hey its not working….

Is there something like addmonths include here?

[jjfabian]

You can use addmonths in QlikView. Look in the QlikView help, it's very detailed.

I generally use addmonths as part of Set Analysis to display rolling months in charts, etc.

[#9]

Hi,

I think you can use like this

sum({1<Datefield={">=$(=addmonths(monthend(max(Datefield=))+1,-12)) <=$(=max(Datefield))"}>}

Sales)