topic StartDate and EndDate with Calendar Object in QlikView

StartDate and EndDate with Calendar Object

rkpatelqlikview — Thu, 25 Oct 2018 06:55:02 GMT

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 — Thu, 25 Oct 2018 07:13:05 GMT

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 — Thu, 25 Oct 2018 07:15:02 GMT

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 — Thu, 25 Oct 2018 07:15:06 GMT

Hi Kumar. Check this

rkpatelqlikview — Thu, 25 Oct 2018 07:59:27 GMT

Dear Andrey,

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

Thanks

andrey_krylov — Thu, 25 Oct 2018 08:16:56 GMT

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