Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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