Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get start date and end date from a standard chosen period

I'm trying to get the startdate of a chosen period (Year and month chosen from two listboxes on a standard master calendar). This is the standard way of representing time in an application.

I am able to get the first year and the first month on doing set analysis, but when i do furter set analysis on that result to get the first date, then I get the errormessage shown in the textbox.

Any suggestions on how I can get the first date of a chosen period like this?

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

= date (
   min( {1 <  Dato.Year

= {

$(=Only(if ( len(GetFieldSelections(Dato.Year))= 0 ,'2010', right(GetFieldSelections(Dato.Year),4) )))

  }  >}

Vare.STARTDATO  )
)

View solution in original post

4 Replies
Not applicable
Author

Forgot the screenshot:

screenshot1.jpg

anbu1984
Master III
Master III

What is your expression?

Not applicable
Author

This is the expression (Im only doing it on year for simplicity):

= date (
   min( {1 <  Dato.Year

= {

if ( len(GetFieldSelections(Dato.Year))= 0 ,'2010', right(GetFieldSelections(Dato.Year),4) )

  }  >}

Vare.STARTDATO  )
)

anbu1984
Master III
Master III

= date (
   min( {1 <  Dato.Year

= {

$(=Only(if ( len(GetFieldSelections(Dato.Year))= 0 ,'2010', right(GetFieldSelections(Dato.Year),4) )))

  }  >}

Vare.STARTDATO  )
)