Please help me to set action in text object based on below scenario?

[durgabhavani]

Hi All,

I have below dates.

Date

01-May-17

15-May-17

12-May-17

13-May-17

10-May-17

03-Jun-17

13-Jun-17

15-Jun-17

17-Jun-17

15-Jun-17

29-Jun-17

When i click on text object I need to get data from the minimum date of current month to maximum date of curent month. (if current month will be increased to july, aug, sep .....) eventhough i need to follow the same rule.

what is the function need to use to get the minimum date in the date field of current month?

expected minimum date is 03-Jun-17.

Please advice.

Thanks,

Durga

[nehasaxena]

Why do you need date to be selected, I mean you can use month as a select field as action in text box. When you click on text box it will select current month that indirectly select min date to max date data for current month.

Give us more details about the requirement.

Regards,

Neha

[durgabhavani]

Thanks for reply neha.

Please find the attached sample application.

My report have historic data but by default, End user want to see only data from min date of current month to max date of current month.

1. Data needs to be filtered based on the calender input.
2. Once I click on clear all button then data selection needs to be cleared and should show the data between the current month range.
( ex: if we filtered May month (1st to 31st) data through calender and then click on clear button and data needs to be filtered from (June 3rd to June 29th ).

Thanks,

Durga !

[tresesco]

Like this?

Count({<Date = {">=$(=MonthStart(Min(Date))) <=$(=MonthEnd(Max(Date)))"}>}ID)

[durgabhavani]

seems the above expression will get data from min date of all dates (i.e 01-May-2017), but i need data from 03-Jun-2017 as it is min date of current month.

[Sergey_Shuklin]

Hello, Durga!

I can't use your test.qvw, so I'll explane on phony data.

For instance you have a load:

LOAD * Inline

[mon, val

01.01.2017,10

05.01.2017,20

01.02.2017,30

17.02.2017,40

22.02.2017,50];

And you have a text object. Go to the Action tab in it and set an action "Select in Field". Set field for searching is "mon" and Search String is:

='>=$(#=monthstart(max(mon))) <=$(#=monthend(max(mon)))'

After that when you will click on the text object you will get current month selected in field "mon".

[tresesco]

If you don't have data for those dates (1,2), then you get the output as you wish to get I believe. However, if you have master calendar with all dates and you want to avoid those dates with no data in the expression, you could create a duplicate date from transaction table and use that like:

Count({<Date = {">=$(=Date(Min(Date))) <=$(=Date(Max(Date)))"}>}ID)