Browsed by
Category: Qlikview

Automatic Refresh and maintain open Session in Ajax (UPDATE)

Automatic Refresh and maintain open Session in Ajax (UPDATE)

A little while ago I talked about creating an automatic refresh in Qlikview….STOP! There is a better way in my opinion at least. Rather than setting up reload script and having the entire page reload (ugly white page refresh anyone?), we can simply use the elementFromPoint() method with a HTML DOM click(), setting the X and Y coordinates to click an empty part of your dashboard. This effectively causes Qlikview to use ajax to refresh its elements for a much cleaner update….

Read More Read More

Automatic Refresh and maintain open Session in Ajax

Automatic Refresh and maintain open Session in Ajax

By default, QlikView Server will terminate inactive sessions based upon various settings in the QlikView Management Console. However, there may be situations where one needs to maintain a session, without user interaction. One example would be presenting information on a display in an office, a show booth, or a manufacturing floor. This article provides an example on how to solve the above issue using the Ajax client. This will require altering and customising code shipped with QlikView Server. All customisation…

Read More Read More

“NOT LIKE” in Qlikview

“NOT LIKE” in Qlikview

Tried using ‘Not Like’ or ‘<>’ in your Qlikview loaders. Don’t bother as it doesn’t work! Wild match is the only replacement for like in Qlikview and is actually more advantageous as it allows multiple wild ‘likes’ in the same statement as below.

   

How to detach a table box

How to detach a table box

Detaching an object means that it becomes static and no longer responds to selection changes. So you are detaching from the selection state, not from other objects.If you need to ignore specific selections, you can use set analysis in your expression to “detach” the expression from those selections. A table box does not have a detach setting. The only way to ‘detach’ it is to use an alternate state. You could use a straight table box option with all the…

Read More Read More