Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Disable Dates in Qwidget Date picker

Hi all,

jagan

hic

I am Using date picker in my app,

I tried to disable dates using min date and max date, but dates are not disabling.

I used below expression:

<wi-datepicker bind-qs-var="vEndDate" popup="true" default="vMaxDate" min-date="vMinDate" max-date="vMaxDate">

</wi-datepicker>

variables and load script:

CalendarTemp:

LOAD

  Max(CanonicalDate) AS DateMax,

  Min(CanonicalDate) AS DateMin

RESIDENT CalendarMaster;

LET vMaxDate = FieldValue('DateMax', 1);

LET vMinDate = FieldValue('DateMin', 1) -1; // Needed to control the minum date autogenerated in Sales table is included in the MasterCalendar

DROP TABLE CalendarTemp;

let vStartDate = Date('$(vMinDate)');

let vEndDate = Date('$(vMaxDate)');

let vYesterday = date(vMaxDate)-1;

Thanks,

Pramod

16 Replies
Anonymous
Not applicable
Author

date(date(max(Date),'YYYY-MM-DD') - date(Date,'YYYY-MM-DD'),'YYYY-MM-DD')

Not applicable
Author

Max(date) means highest date in db

for example: for today max(date) is 12-8-2015, all the dates after today should be disabled.

Same way min(date) the lowest date in the DB

for example: if last date in DB is 08-08-2014 then all the dates before this date must be disabled.

brijeshvma
Partner - Creator
Partner - Creator

hi pramod,

Can u please share me  Qwidget Date Picker zip file . i want to use same in my one application .

please can u send me on my email id : brijeshm19@gmail.com

Thanks in Advanced.

reddy-s
Master II
Master II

Hi Pramodgc3,

Can you forward the qWidget zip file to me as well?

ds.sangram.reddy@gmail.com

Thanks,

Sangram

Not applicable
Author

you can download from below link;

Download qWidget

reddy-s
Master II
Master II

Hi Promod,

Access to that document is denied. Can you please forward it to my mail?

Thanks,

Sangram

brijeshvma
Partner - Creator
Partner - Creator

Hi Promod,

Thanks for Your reply .. But i am Getting Access denied error

Error.png