topic Calendar Disabled When View On QV Server in QlikView

Calendar Disabled When View On QV Server

Wed, 11 Jan 2012 19:02:08 GMT

Hello,

I noticed that calerdar is displayed correctly when developed in Qlikview Desktop. However, when display on QV Server, Calerdar selection is disabled.

Attached is the calendar user sees, which you can tell all other dates (besides today) are disabled.

Any reason why? Is this a known bug?

Thanks for your help!

Calendar Disabled When View On QV Server

rwunderlich — Wed, 11 Jan 2012 19:38:53 GMT

That doesn't look like a standard calendar object. It looks like a pivot table formatted to be a calendar?

-Rob

Calendar Disabled When View On QV Server

Wed, 11 Jan 2012 20:21:50 GMT

VERY STRANGE.

It is definitely a calendar object (see attachment) that I see when clicking on the object.

Here is two scenario that I am experiencing: (mailingdate is the field name)

mailingdate --> "01/24/2011"

Result --> Calendar object shows up but does not allow user to select other dates (see original attachment)

date(mailingdate) --> "1/24/2011"

Result --> Calendar object DOES NOT show up when I click on the icon!!!

Re: Calendar Disabled When View On QV Server

Thu, 12 Jan 2012 00:24:14 GMT

Also, I thought Calendar feature was working in QV v10 SR2, so the recent upgrade to QV v11 might have disabled the Calendar feature. Would that be the case? Anyone also experience this bug? Or is there some settings on the server that I have to enable for Calendar controls to work successfully?

Sincerely.

Calendar Disabled When View On QV Server

rwunderlich — Thu, 12 Jan 2012 06:23:03 GMT

Your screenshot is not a calendar object I recognize. Any way you can post a qvw?

Re: Calendar Disabled When View On QV Server

Thu, 12 Jan 2012 23:26:54 GMT

I've attached the QVW.

Two issues:

1. Calendar is disabled (see screenshot attachment)

2. MailingDate filters DID NOT show distinct values (1/1/2012, 1/2/2012). Why is it showing all the duplicate values? Transaction_Date is more granular, so underlying dataset has duplicate MailingDate values, but filter should not have dups, right?

Thanks for your help!

Re: Calendar Disabled When View On QV Server

rwunderlich — Fri, 13 Jan 2012 00:38:40 GMT

My fault. I didn't recognize the Calendar in webview.

Your dates are repeating in the listboxes and don't match anything in the Calendar because the MAILINGDATE and LAWDATE values are not dates -- they are timestamps. They still have the fractional portion that represents a time. In your script:

Date(transaction_date,'MM/DD/YYYY') AS MAILINGDATE

only changes the display format. It does not convert to a date value. The correct statement is:

Date(floor(transaction_date),'MM/DD/YYYY') AS MAILINGDATE

-Rob

Re: Calendar Disabled When View On QV Server

Fri, 13 Jan 2012 03:20:38 GMT

That solved the distinct list box issue.

However, the major bug is not resolved yet!

As you can see from the the attached, on the server version, the calendar navigation is still DISABLED. User is unable to select other dates.

Server version is --> QV 11 11149

Your help is much appreciated for this pesky bug.

Re: Calendar Disabled When View On QV Server

Wed, 09 May 2012 01:57:43 GMT

I have exactly the same issue! And I'm using the newest version (SR1 11282) I have no problem displaying in the desktop webview. But when I open it through the AJAX client, the calendar is disabled! Is this a bug?

Calendar in AJAX:-

Same calendar in webview:-

Re: Calendar Disabled When View On QV Server

peter_rtf06 — Tue, 22 May 2012 16:38:30 GMT

Wow!!! I have exactly the same problem!!!!! any idea?

Calendar Disabled When View On QV Server

Fri, 25 May 2012 06:21:52 GMT

Confirmed that this is a bug from QlikTech Support. According to Support, currently there is no date for a fix...

Re: Calendar Disabled When View On QV Server

Mon, 28 May 2012 22:16:22 GMT

I don't think there's issue with the calendar controls. It was date formatting not consistent for me, so check your date format for all your calendar controls.

Happy Memorial To All Our Troops (past and present)!

Re: Calendar Disabled When View On QV Server

Tue, 29 May 2012 01:10:56 GMT

Hmm... can you try the following QVW and see whether it works for you? (Not working for me...)

Re: Calendar Disabled When View On QV Server

Anonymous — Wed, 21 Nov 2012 18:26:54 GMT

Having the same issue. Has anyone found a solution to this?

Re: Calendar Disabled When View On QV Server

Thu, 22 Nov 2012 00:48:18 GMT

Hi Gene,

The issue has been fixed in QV11SR2 (11414). Maybe you can give it a try.

Re: Calendar Disabled When View On QV Server

Anonymous — Fri, 23 Nov 2012 13:45:39 GMT

Thank you. I'll give it a try, we're stil on SR1.

Re: Calendar Disabled When View On QV Server

Thu, 07 Feb 2013 13:33:06 GMT

Was the issue solved? I have the same problem as you have/had .. we have the version 11.0.11426.0 SR2

Re: Calendar Disabled When View On QV Server

Anonymous — Wed, 27 Feb 2013 18:38:50 GMT

We upgraded to 11.2. Issue has been resolved.

Re: Calendar Disabled When View On QV Server

Mon, 18 Mar 2013 16:39:28 GMT

Even in QV Server 11.2 SR1, if an Internet Explorer 10 user selects a sheet containing any calendar objects, these objects are not displayed and the whole document becomes unresponsive.