Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to show the value "from date" to "to date"

Dear Friends

    I wanna show the value from one date to another date. I 've date column in my table. I don't know how to make this entry. And pls tell me how can I do this in dynamic calendar .............

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

Follow the steps:

  • Create two variables as STARTDATE and ENDDATE
  • Next select a Calendar object like below: (Assign Min(Date_Field ) and Max(Date_Field) to the vaiable)


  • Create similar object for ENDDATE variable.
  • Next create a button and assign value as below: (Field name should be your Date fields)

  • Search string Expression:  ='>=' & Date(STARTDATE, 'DD/MM/YYYY hh:mm:ss') & '<=' & Date(ENDDATE, 'DD/MM/YYYY hh:mm:ss')
  • Finally select date from and To and press this filter button to see the result.

Thanks,

AS

View solution in original post

9 Replies
danieloberbilli
Specialist II
Specialist II

maybe this helps:  Selecting Arbitrary Date Ranges    https://community.qlik.com/message/288110#288110

Not applicable
Author

Bro thank u for ur resp. But I 've restriction to play that videos.. so pls send me how can I use dynamic calendar here...

amit_saini
Master III
Master III

Hi,

See the attachment.

Thanks,

AS

Not applicable
Author

amit  pls send the query I can't open it....

amit_saini
Master III
Master III

Follow the steps:

  • Create two variables as STARTDATE and ENDDATE
  • Next select a Calendar object like below: (Assign Min(Date_Field ) and Max(Date_Field) to the vaiable)


  • Create similar object for ENDDATE variable.
  • Next create a button and assign value as below: (Field name should be your Date fields)

  • Search string Expression:  ='>=' & Date(STARTDATE, 'DD/MM/YYYY hh:mm:ss') & '<=' & Date(ENDDATE, 'DD/MM/YYYY hh:mm:ss')
  • Finally select date from and To and press this filter button to see the result.

Thanks,

AS

Not applicable
Author

thank you very much amit....

amit_saini
Master III
Master III

Cheers!

Anonymous
Not applicable
Author

Great video, Amit

Thank you so much.

N.

mohan2391
Creator II
Creator II

hi

It didn't work for me. I want to show bar chart of familyname-revenue(dimension-expression) by using revenue_date. I have to create 2 objects with startdate&enddate. so that bar chart must display the data for that period.

Pls help me