topic Expression Overview crashes in QlikView

Expression Overview crashes

Mon, 15 Nov 2010 00:37:46 GMT

Hi,

I'm new to Qlikview so I'm pretty certain I have done something to create this problem myself, however I have a document in which whenever I attempt open the Expression Overview (using either the menu of shortcut keys) Qlikview freezes. Any ideas? Is there somewhere I can post the file? This doesn't happen when I'm in other files...

Regards,

Rob

Expression Overview crashes

Mon, 15 Nov 2010 01:50:38 GMT

Hi Rob,

I had the same thing happen to me last week. I was running v9 service pack 1 of QV. I upgraded to service pack 5 and the problem does not happen anymore. I was caused by another developer including in the group tab on the overview a formula which my version couldn't handle.

Hope this helps,

Sheilana

Expression Overview crashes

Tue, 16 Nov 2010 00:01:26 GMT

Thanks Sheilana. I have (re)installed the latest version to no avail. Can you point me to where I get the service pack from?

Expression Overview crashes

ddking — Fri, 10 Dec 2010 19:38:58 GMT

Hi! I've got same problem on QV10 release.

Expression Overview crashes

ddking — Mon, 13 Dec 2010 09:33:39 GMT

After I press Expression Overview QV.exe is behaving like there is an invisible modal window. May be Expression Overview is creating but not showing for some reason?

Expression Overview crashes

Thu, 28 Apr 2011 09:11:02 GMT

Hi,

I've encountered the same trouble on QlikView V10.00.8815.6 SR1 (Free Edition) After some hard bug hunt, I think I finally found what causes this problem on my QlikView document : It occurs when one or more listbox use at least one right side expression.

The Expression Overview won't crash if you don't use any functions (when using Sum,concat,Count(FieldName) : it crashes, when using a field (=FieldName), a constant ('1', =1) it does not, but the Expression is not displayed in the Expression Overview)

Do you use them ?

I can't find any other reference to this issue. Has it been fixed in the non-free Version or in a later release ? Or is it still occurring ?
Is it worth reporting ? If yes, where should I report it ? I'm new in this community ...

Thanks,

Laurent

Expression Overview crashes

ddking — Thu, 28 Apr 2011 09:26:10 GMT

Hi,

all my docs was made in QV9, so there are no right side expressions in listboxes.

I've mailed this issue to QV support and this bug is listed as fixed in 10SR2 release notes (Bug ID: 34623). I didn't checked it on 10SR2 myself, just readed release notes. So, you could try 10SR2 to see if the bug is gone.

Expression Overview crashes

Thu, 28 Apr 2011 09:32:01 GMT

Thanks for the quick reply.

I'll check it then post whether this issue is fixed.

Laurent,

Re: Expression Overview crashes

Tue, 07 Jun 2011 21:11:15 GMT

This behavior still occurs for me while working on a fairly complex qvw file, after selecting the "Settings.Expression Overview" menuitem, using QlikView Desktop version 10.00.8935.7 SR2 64-bit Edition (x64), licensed and registered.

I wouldn't necessarily say that it "crashes"; more that it freezes, becomes locked up, becomes unresponsive, and there is a chime sound when I click anywhere on the application. I cannot say I let this bother me too much; I just try to stay away from "Expression Overview" when I can.

Note: Same/similar behavior occurs at times in the "Edit Expression" dialogbox, when you double-click on the autocomplete item (Microsoft calls it IntelliSense). Eg: The example qvw file has, among its fields, the following two: [Q1 Total], Q1_Total_Image. In the "Edit Expression" dialogbox, type "Q1" then double-click on the autocompleted item of "Q1 Total". The "Edit Expression" dialogbox nicely resolves the item and displays [Q1 Total]. But in this example you realize that you actually wanted the image field, so you move the cursor to the beginning of [Q1 Total] and click the Del key once, in order to delete the opening square bracket character. Autocomplete presents two items and this time double-click on the second item, "Q1_Total_Image". The "Edit Expression" dialogbox disappears and QlikView Desktop becomes a frozen chiming machine.

Tip: A way that I get out of this situation, without losing my work, is the following steps:

Launch Windows "Task Manager" (I right-mouse click on the Windows taskbar.)
Locate on the Applications tab and select the task representing QlikView Desktop.
Click the "End Task" button.
IMPORTANT: When QlikView Desktop comes back to life and asks me if I'd like to save changes to my current file, I click the *Cancel* button.
If the Task Manager's "End Program" dialogbox doesn't already disappear on its own, click the *Cancel* button on that, too.
Good to go, continue working with QlikView Desktop...

I hope this helps someone.

D.Will, ATP Engineering

Expression Overview crashes

Wed, 08 Jun 2011 08:58:10 GMT

Hi,

I've just installed the SR2 ( 10.00.8935.7 SR2, Desktop Edition, X86). The Expression Overview does not freeze (Yes, it was a freeze, and not a crash, sorry) anymore when using left side expression in a ListBox (Tested with 3 expressions in different listboxes).

@D.Will : I tried to recreate your scenario on this version. It sure did something funny :

1. count( DISTINCT [ID COL])

2. count( DISTINCT ID COL])

3. count(DISID_COL_SID COL] )

But it didn't freeze or did anything else

As far as I'm concerned, this issue seems to have been solved on the X86 version,

Laurent.

PS : Don't know how you manage to avoid using Expression Overview in complex QVW. It saves a lot of time and effort when performing changes.

Expression Overview crashes

Wed, 08 Jun 2011 14:22:26 GMT

Hi Laurent @lschSopra,

That's good news, and you raise good points about using Expression Overview. (Friend, my reply to this thread, including crash vs freeze, wasn't intended to be aimed at you directly; I meant to contribute to the conversation so I apologize for the mixup.) I will have to look more into this "left side expression in a ListBox" you speak of. Thanks for writing!

D.Will, ATP Engineering

Expression Overview crashes

Wed, 08 Jun 2011 14:49:21 GMT

Argh, this issue has not been resolved totally : the menu freezed once (out of around 10-15 times) today and I can't reproduce the problem.

So pray before opening the menu (and save your document, It should be more useful)

Laurent,

PS : the LB expressions are not on the left but on the right. My mistake ...

Expression Overview crashes

johanfo2 — Tue, 05 Jul 2011 11:34:18 GMT

I can confirm that this problem still exists in QlikView 10 SR3

Expression Overview crashes

Thu, 06 Oct 2011 10:06:07 GMT

I can confirm that its still an issue in SR3 too, although it seems that it does work partially if you open Expression Overview straight after you have opened the QVW file

Expression Overview crashes

johanfo2 — Fri, 07 Oct 2011 07:02:51 GMT

Strange thing this isn't fixed yet! Should be a trivial thing to track down, when it is so consistent and frequent.

Re: Expression Overview crashes

Thu, 13 Sep 2012 21:28:49 GMT

@ D.Will, ATP Engineering

Thanks this helped me save my 3 hr task.