topic Re: Current Selection Box to show Date in QlikView

Current Selection Box to show Date

Tue, 28 Jan 2014 09:39:26 GMT

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

Re: Current Selection Box to show Date

Tue, 28 Jan 2014 09:42:21 GMT

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

Re: Current Selection Box to show Date

nilesh_gangurde — Tue, 28 Jan 2014 09:43:39 GMT

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

Re: Current Selection Box to show Date

brijesh1991 — Tue, 28 Jan 2014 09:50:17 GMT

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