How to implement calendar object

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

Hi ,

I am new to qlik.

Thanks in advance,

I have one table that has one date column l.e delivery date, the requirement is user have to view the data in range for that I have to take two calendar object.

In first calendar object he will select the min date and in second calendar object he will select max date and result should be shown between min date and max date.

Re: How to implement calendar object

Anil_Babu_Samineni — Thu, 02 Mar 2017 04:05:57 GMT

You may forget this video

Selecting Arbitrary Date Ranges

Re: How to implement calendar object

ramasaisaksoft — Thu, 02 Mar 2017 06:56:58 GMT

you need to create 2 variables in variable overview (Ctrl+V)

Step 1 :

vminFromDate=min(delivery date)

vMaxFromDate=max(delivery date)

vminToDate=min(delivery date)

vMaxToDate=max(delivery date)

Step 2:

Now create 1st calendar object

properties of the object

General Tab-->Variable(s) select the Radio button-->select the field as delivery date

Down side u can find 2 boxes 1 min value--> write your min variable (=vminFromDate)

2 Max Value-->write your Max Value(=vMaxFromDate)

Caption Tab-->Delivery From Date

Step 3:

Now create 2nd calendar object

properties of the object

General Tab-->Variable(s) select the Radio button-->select the field as delivery date

Down side u can find 2 boxes 1 min value--> write your min variable (=vminToDate)

2 Max Value-->write your Max Value(=vMaxToDate)

Caption Tab-->Delivery To Date

Step 4:

Now create a Straight table

fetch date field and change that field with if condition

=if(delivery date>=min(delivery From date) and delivery date<max(delivery From date) or

delivery date>=min(delivery To date) and delivery date<max(delivery To date) ,delivery date)

Note :(Check this if condition properly once due to time problem i didn't check properly)

this dimension will restrict between From date between min & Max as well as To Date Between min & Max date

and now u can add your remaining dimensions and Expressions as it is.

Check and let us know if you have any doubts,

else

if you feel you got the solution for your issue please close the thread by clicking "Correct Answer"

topic Re: How to implement calendar object in QlikView

How to implement calendar object

Re: How to implement calendar object

Re: How to implement calendar object