topic Re: Expression in web view in QlikView

Expression in web view

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

Some expressions are not counted or wrong in Web View, when moving to the desktop view all values are calculated correctly.

Does anyone have insight on what might cause incorrect numbers in web view?

Re: Expression in web view

maleksafa — Fri, 12 Dec 2014 11:27:30 GMT

can you share some of these expressions? are you using macros or normal expressions?

Re: Expression in web view

Fri, 12 Dec 2014 11:33:15 GMT

I use normal expressions.

For Example:

if(Index($OpenPriceType,'0'),Count({$< OpenDate ={"<=$(vToDate)"}, CloseDate ={">=$(vFromDate)"}>} DISTINCT $PositionId),if(Index($OpenPriceType,'1'),Count({$<IsOpenDatePublish = {'True'}, OpenDate ={"<=$(vToDate)"}, CloseDate ={">=$(vFromDate)"}>} DISTINCT $PositionId),Count({$<IsOpenDateAfterPublish = {'True'}, OpenDate ={"<=$(vToDate)"}, CloseDate ={">=$(vFromDate)"}>} DISTINCT $PositionId)))

Re: Expression in web view

maleksafa — Fri, 12 Dec 2014 11:37:28 GMT

i cannot think of anything that might cause this weird behavior, can you maybe upload a sample dashboard?

Re: Expression in web view

jonathandienst — Fri, 12 Dec 2014 11:46:49 GMT

To test this create a blank page with a couple of text boxes, break the expression into its three parts (ie without the if then else) and put each part as an expression in a text box, and check that each part is returning the same value as in web view.

This will isolate the problem and should help in resolving it.

HTH

Jonathan

Re: Expression in web view

Fri, 12 Dec 2014 12:13:13 GMT

Thanks, it helped to find the problem.

I have a trigger for opening the document (SELECT field, the field is used as a filter). If the document is opened in a Web View - this trigger doesn't turn on. Maybe you have encountered a similar problem? Maybe there are alternative?

Re: Expression in web view

Peter_Cammaert — Fri, 12 Dec 2014 12:57:21 GMT

Unfortunately, the story doesn't end well. Event triggers are not supported by the AJAX client, so it says in chapter 80.3 of the QlikView Reference Manual. Since WebView is nothing more than the HTML-core of IE being used as a rendering engine (analogous to the AJAX client); there you have it...

Peter