Selections are not working in Triggers

[SatyaPaleti]

Hi Friends,

I am Having a data, Fields in the data are  Qty, Cost, Profit etc....

I have created a Dashboard by using a these fields and taking Date as Dimension.

My Requirement is

Date has values 06/10/2015(MM/DD/YYYY) to 07/04/2015(MM/DD/YYYY) and I am calculating fields by taking these dates as Dimension.

I have to create a Calendar

I am having only 1 year,2 Quarters,2 Months and 4 Weeks

But According to requirement. I should outer join with  Master calendar

This Master calendar has Dates 01/01/2005(MM/DD/YYYY) to 07/01/2015(MM/DD/YYYY) . It's Huge data.

So In Calendar I have 10 Years, It will show as usual 4 Quarters , 12 Months and 53 weeks

When I have Created Calendar in Dashboard it showing

Year :- 2005 to 2015

Quarters :- Q1,Q2,Q3,Q4

Months :- Jan to Dec

Weeks :- 1 to 53

when ever i click on Q1 or Q4 Values shows empty because no values for Q1 & Q4.

When ever i enter in to dashboard.  it have to show default values for dates I have (Not for Master Calendar Dates)

I  am using Triggers for this. In selections I am using --> select field --> @ Field I am giving Date and In Expression I am using

if(Date>= Min(Date) and Date <= Max(Date),[Date]) No values are selecting by default. I have to show default values by entering in to sheet.

Just like Default Year I have i.e., 2015

Quarter Q2,Q3

Months :- Jun,Jul

So Can any one help me to resolve this issue

Thank you,

Satya

.

[m_woolf]

In your expression try something like:

>= Min(Date)<= Max(Date)

If you search the community for select date range, you will find many posts.

[SatyaPaleti]

Thank you Woolf. but this expression is not working. can you forward any link related to this

[#4]

Firstly, what is the purpose of adding 10 yrs data into Master Calendar even though you have data from 6/10/2015

[SatyaPaleti]

Just for example I said  there is 10 years data

[m_woolf]

The use of variables to filter a date range

Now I have searched the forum for you.