Calendar Object

[#1]

Hi All,

I am having a "DATE" column.  I need to place 2 calendar objects as FROM DATE and TO DATE.

I placed 2 calendar objects and in Data field I selected the DATE column.

But the date which i am selecting is not getting reflected.

Can anyone help me ?

Thanks,

Praveen

[#2]

Hi Shyamal,

Thanks for your reply.

I tried it already,in the same way, but I am not getting it.

Few changes,

I have only  one DATE column and Names.

I need FROM and TO DATE Calendar

[#3]

Not sure if I understand you correctly.

See the changed attached file.

Edit: Since there is no other expression column, I have used Name in the expressions. Ideally you should have one expression other than this.

[#4]

Shyamal,

Consider its Worldcup 2013

I have a NAME column. Its full of  Cricket Players names.

I have a DATE column. Where it has dates from 1st May 2013 to 30 August 2013

I have placed a Table object, which contains -  Name, and Team Name

I m placing a two Calendar Objects, they are : From date and To Date

now I need to see the players who all played between  10th June 2013 to 20th July 2013.

I need to see all players who falls under this Date range.

In your file, Since the data is one 2 values, v can select between the two dates, But I m going to select in Calendar, that too between a Random range.

I think, u got my requirement clear

[suepenick]

Watch this video - you need to set the Event Triggers to make the input box variables work

http://www.bi-tv.com/how-to-add-start-date-and-end-date-calendar-objects-in-qlikview/

[#6]

Thanks Sue

[MK_QSL]

Create a vStartDate and vEndDate Variable...

On Change Them Add a Trigger with Select in Field = YourDate Field and expression '>='&vStartDate&'<='&vEndDate

Hope This help.

[Anonymous]

Hi Manish,

   Can you share some sample appln for this?