Expression in web view

[#1]

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?

[maleksafa]

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

[#3]

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]

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

[jonathandienst]

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

[#6]

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?

[Peter_Cammaert · Accepted solution]

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