restrict date based on another date??

[soha1902]

Hi All,

I am using one bar chart where FirstDate is my dimension and Sum(Sales) is my expression.

Now my requirement is, if I user select any date from SecondDate then in chart only thsose date will display which is less then or equal to SecondDate.

For eg. if user select 6/14/2014 from SecondDate filter then chart will show from 6/9/2014 to 3/17/2014.

Please find sample app in attachment.

[vgutkovsky]

Well, that kind of depends on the relationship of the 2 date fields. How are they connected in the data model?

Regards,

Vlad

[soha1902]

Hi all,

Any suggestions???

[sujeetsingh]

Soha,

You can do the trigger on one date field as select in field and quote condition as where date less than the selected.

The other way is you define a variable which collect the current selected date from Date1 and then use the dimension limit option with this variable

[sujeetsingh]

One more option is that you use calculated dimension as if Selected variable is not null then use date in dimension in chart which is less than or equal to the selected date, else the date by default.

[tresesco]

Try something like:

=Sum({<FirstDate={"<=SecondDate"}>}Sales)

[Gysbert_Wassenaar]

I suggest you upload a small example document with some data.

[vgutkovsky]

As I mentioned, we need to understand how the 2 fields are related to each other first. Gysbert is right, upload a reduced QVW.

Regards,

Vlad