Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Honored Contributor III

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

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

9 Replies
danieloberbilli
Valued Contributor II

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

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

Not applicable

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

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
Honored Contributor III

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

Hi,

See the attachment.

Thanks,

AS

Not applicable

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

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

amit_saini
Honored Contributor III

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

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

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

thank you very much amit....

amit_saini
Honored Contributor III

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

Cheers!

edp
Contributor

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

Great video, Amit

Thank you so much.

N.

mohan2391
Contributor

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

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

Community Browser