Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my application I want to show the current quarter data.It means if a quarter starts from 21st march 2014 to 21st june 2014 than my application shows data only according to that current quarter and nd application will automatically update according to the current quarter.attached a sample excel which is showing how data is given in excel sheet.
need help to write script
Can you explain little bit more about your requirement.
--Jai
you need to apply like wise comparison please study attached qvw will help you.
Vikas
We can achieve this in below manner...
1. First select Quarter_Name for the current date and assign it to the variable.
2. Then read th data from excel, having current Quarter_Name. (Variable)
Regards,
Pradeep
@vikasMahajan I am Unable to find attach QVW file
pfa
@Jai what i want is that to show data according to current quarter in my application.
i have given an example like i specify Quarter as(Start date 21 jan2014,End date 21 mar 2014),
So I want to show that which falls in that date only.i dnt want to show historical data.i want to show only current data.
i attached a sample which shows how my data looks like in an excel.
if you need more explanation please let me know i will tell you my requirement.
We can achieve this in design side also.. we can opt the option "on opening document"
below is the steps to be followed
1. Load the table.
2. Seettings--> Document Properties(CTRL+ALT+D) --> Triggers --> Document Even Triggers--> Add actions
we have to add 2 actions here, one for Year and other for Quarter
1) onOpen--> Add--> Select in Field
Field name : Year
Search String : Year(today())
2) onOpen--> Add--> Select in Field
Field Name : Quarter (in your example this is .. Q)
Search String : 'Q' &Ceil(month(today())/3)
How this works is... on opening the document it will check the today's year and quarter and accordingly it selects the data..
Thanks,
Pradeep
If this solution works for you, mark it is Correct Answer.. So that it if any others faces same issue can look into this.
Regards,
Pradeep
I will surely mark it if it works.