need suggestion

[#1]

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

[jsingh71]

Can you explain little bit more about your requirement.

--Jai

[vikasmahajan]

you need to apply like wise comparison please study attached qvw will help you.

Vikas

[PradeepReddy]

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

[#5]

@vikasMahajan I am Unable to find attach QVW file

[vikasmahajan]

pfa

[#7]

@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.

[PradeepReddy]

paridhi agrawal

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

[PradeepReddy]

paridhi agrawal

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

[#10]

I will surely mark it if it works.