Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a request for a QV model where the user can enter a from date and to date. The from and to dates will be used to determine a range for showing all tickets that were either open or closed during that period. I have both open and closed dates on my ticket table. Does anyone have any recommendations on how to only select only the tickets that were either open or closed during the range the user selected.
Thanks
hi,
Try this:
step1: Create two variablt say: vstartdate and venddate
step2: create two calander objects/inputbox to assigne the desired dates to those variables..
step3: you can use those variables in the setanalysis like
=only({<opendate={">=$(vstartdate)"},closedate={"<=$(venddate)"}>}tickets)
HTH
Sushil