Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Current Selection Box to show Date

Good Morning.

I have build a report on Qlikview to show all the call logged on our helpdesk database.  I have a calendar object which shows my Start and End Date and I pull up the details in between and equaling those dates.  However as I have to set this as a number field so that I can get my Variable to work correctly, the current selections box now shows as a number instead of a date.

Is there anyway of changing this without getting my logdate field to date as it will stop me being able to search between the date criteria.

Regards,

Jon Ditchfield

3 Replies
Not applicable

Re: Current Selection Box to show Date

Hi jon

Yes  no worries

you date is under numeric format but you can show it as =date(DateFieldName, 'DD/MM/YY')  for example or others formats you can find in Help tab

best regards

Chris

Partner
Partner

Re: Current Selection Box to show Date

Hi,

you can change the date to number using num() function.

and number to date using Date() function.

and these functions you can use at script level as well as at frontend.

so take date AS NUMBER from script and convert the same into date at frontend

-Nilesh

Partner
Partner

Re: Current Selection Box to show Date

there must be some variable in your start date and end date calender object, right?

goto those both calender object's number tab and set it Date format

See the attachment

Let me know if you need exact example