StartDate and EndDate with Calendar Object

[rkpatelqlikview]

Dear Experts,

Please anyone help on this start date and end date selections.

I created variables for startdate and end date.

I put a OnOpen trigger for date fields in document properties.

Still its not working. Whenever i select the start date and end date the sales should be displayed with in that range.

Any another way to fix this.

Thanks in advance

[Anonymous]

Hi Kumar,

Please find attached document and hope this helps. For the above scenario to work no need to have trigger this can be achieved in Set Analysis.

Thanks,

Vivek

[Anonymous]

there is no Connection between your datevariables and your field date. So within a table box you will see al Dates.

you Need to use a straight table and define a caluclated Dimension like

=if (Date>=startdate and Date<= enddate, Date)

by the way: your on open Trigger is not correct as it only Shows <= value

use instead (i suppose you donot give an absolut date, but a variable? a field? thenyou Need to work with $)

='>="27.08.2018"<=$(=Today())'

[andrey_krylov · Accepted solution]

Hi Kumar. Check this

[rkpatelqlikview]

Dear Andrey,

This what i expected. thanks for your great help. There is a variable actions we need to give.

Thanks

[andrey_krylov]

You're always welcome and I'm glad I was helpful.