This has been posted to the QlikView Expressor forum, which is more specific to QlikView Expressor. I recommend you post this to the general QlikCommunity.
Also, have you considered using binary date flags in your load scripts? That way you could do simple math rather than nested IF statements.
Thanks Tyler.I can see only Qlikview Expressor in my qlik community Tab.As iam new to this community,can you please guide me how can i post my discussions in general Qlikcommunity.
Can you please help me out how can i implement the Data using InMonthtodate functions(I want the data for months only using InMonthtodate functions).
Welcome to the community!
The general QlikCommunity can be found here: http://community.qlik.com/index.jspa
Perumal has a good idea. Do what you can to avoid IF and other calculations like InMonth in your expressions. Better to create binary flags in the load script which dynamically do this each time you reload. Then you are pushing more of the calculation work to the load script instead of the application (better user experience).