Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Expression in web view

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?

Tags (2)
1 Solution

Accepted Solutions

Re: Expression in web view

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...

NoEventTriggersInAJAX.jpg

Peter

6 Replies
maleksafa
Valued Contributor

Re: Expression in web view

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

Not applicable

Re: Expression in web view

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)))

maleksafa
Valued Contributor

Re: Expression in web view

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

MVP
MVP

Re: Expression in web view

Hi

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

Not applicable

Re: Expression in web view

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

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...

NoEventTriggersInAJAX.jpg

Peter

Community Browser