Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Expression Overview setting

Hi all,

I'm using 11 SR1 and am not always able to open the Expression Overview via the Setting drop down menu, or Ctrl + Alt + E. If I open a new, blank qvw, it seems to work, but stops popping up after I begin copying in the objects that I'd like to modify via Expression Overview. Is there a setting I need to change?

For what it's worth, I'm not losing access to Variable Overview, or anything else as far as I can tell.

Appreciate any guidance,

Whitney

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Expression Overview setting

Whitney,

There are no settings, as far as I know, but sometimes it takes very long time to open it, especially if there are many expressions.

Regards,

Michael

5 Replies
mov
Esteemed Contributor III

Re: Expression Overview setting

Whitney,

There are no settings, as far as I know, but sometimes it takes very long time to open it, especially if there are many expressions.

Regards,

Michael

Not applicable

Re: Expression Overview setting

Thanks for the info, Michael. I'll take your word for it, but unfortunately patience hasn't helped with this particular file.

alexmosq
New Contributor III

Re: Expression Overview setting

Hi,

Did you get it to work eventually? I have the same problem with a not too complex application. Nothing at all happens when i press Ctrl-Alt-E or when I try to bring up the dialog via the toolbar.

I found an alternative solution however. There is another way to access expression definitions and other structural data.

1. Create a new QV doc.

2. Go into the script editor and click on the Table Files button (i.e. browse for a table file).

3. Browse to the folder where your original .qvw is located and select it (You will have to select "Show all files" in the filetype dropdown first.)

4. Tell QlikView to interpret the QV file as an XML table. (See pic below.)

5. You'll find all the expressions in the the "DocumentSummary\Expression" table.

Make sure you comment out everything else in the automatically generated load script, since you'll end up with circular or synthetic relationships otherwise.

sshot.PNG

yduval75
Contributor III

Re: Expression Overview setting

I think it's because you have implemented a section access in your application and you have gone inside your application throught a user or a ntname.

You can comment it or put an exit script before when you develop.

chhavi376
Contributor II

Re: Expression Overview setting

Hi all,

I had a doubt in the find/replace feature in the expression overview.

There is an expression which i want to modify throughout the application.

The expression is also present in the Layout--> Show--> 'conditional'  PFB:

Capture.PNG

By anyway can i replace this expression also via Expression Overview as it would be very tedious manually?

Thanks in advance.

Regards,

Chhavi.

Community Browser