Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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