topic Re: calender object in QlikView

calender object

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

I have 2 calender object "From" and "To"

after i clear the screen "From" should show min Date

and "To" should show max Date

can any one help me out

Re: calender object

Clever_Anjos — Wed, 24 Jan 2018 11:16:09 GMT

Are they attached to variables or fields?

Re: calender object

vignesh_s — Wed, 24 Jan 2018 11:17:05 GMT

variables

Re: calender object

Clever_Anjos — Wed, 24 Jan 2018 11:18:33 GMT

And how do you calculate max and min dates?

Re: calender object

vignesh_s — Wed, 24 Jan 2018 11:20:08 GMT

max(date) and min of date

Re: calender object

Clever_Anjos — Wed, 24 Jan 2018 11:29:49 GMT

So you´re using fields, not variables, right?

Re: calender object

rahulpawarb — Wed, 24 Jan 2018 11:30:48 GMT

Hello Vignesh,

Hope that you are doing well!

As a workaround you can follow below approach:

1. Add Two Two Variables (vFrom & vTo) and Calendar Objects (From & To)

2. Associate vFrom & vTo with From & To Calendar Objects respectively

3. Add a button to perform Clear All

4. Add three different Actions under the button by following given order

2.1 Clear All

2.2 Set Variable (Variable: vFrom & Value: =Min(Date))

2.3 Set Variable (Variable: vTo & Value: =Max(Date))

Hope this will help.

Regards!

Rahul Pawar

Re: calender object

vignesh_s — Wed, 24 Jan 2018 11:31:38 GMT

Re: calender object

vignesh_s — Wed, 24 Jan 2018 11:37:12 GMT

Can u provide a sample qvw plz

Re: calender object

rahulpawarb — Thu, 25 Jan 2018 04:59:33 GMT

Please refer sample application file attached herewith.

Regards!

Rahul Pawar

Re: calender object

vignesh_s — Thu, 25 Jan 2018 07:27:16 GMT

thank you

Re: calender object

rahulpawarb — Thu, 25 Jan 2018 08:14:20 GMT

Cheers!

Rahul