topic Re: Result different with IE Plug in vs Web Browser in QlikView

Result different with IE Plug in vs Web Browser

zagzebski — Sat, 12 Mar 2016 23:01:07 GMT

I have the an expression that if viewed in Access Point using Internet Explorer PlugIn returns the accurate value, but if I use the Web Browser version it doesn't evaluate the function properly. Why would certain functions not work with the Web Browser version?

(Note: If I click on a previous year then back to the max year then the expression works in the Web Browser - obviously not acceptable though)

The expression:

=If(InYearToDate(date('03/01/'&max(Year),'MM//DD/YYYY'), date(floor(monthend(today(),-1))), 0),
Sum({$<MajorCategory={'Operating Expense'}, Month={'Mar'}, [Year] = {$(=Max([Year]))}>} [Amount GL]),
Sum({$<MajorCategory={'Operating Expense'}, Month={'Mar'}, [Year] = {$(=Max([Year]))}>} [Amount GL Budget])
)

Thanks in advance.

Zag

Re: Result different with IE Plug in vs Web Browser

petter — Sat, 12 Mar 2016 23:25:17 GMT

There is absolutely no reason why the Ajax-client should return something different from the IE-plugin.

If you give us some more information or even a complete reproducible "demo"-app it would be much easier for us to assist you in tracking down the cause of this or even find out if it is a bug.

Could you also please explain in a little bit less vague terms what you mean by "accurate value"?

Re: Result different with IE Plug in vs Web Browser

zagzebski — Sun, 13 Mar 2016 19:46:36 GMT

Petter - the first image is in IE Plug In (everything works fine). The second image is in Full Browser Version (renders 0 for all Forecast fields). Additionally if I click on a different year in the Full Browser Version then go back to "2016" everything works fine.

I think I may have isolated the problem. There is a trigger that clears the months that seems to be working on IE but not on the Web Browser. Can this happen...triggers not working effectively all the time on Web Browser?

Re: Result different with IE Plug in vs Web Browser

avinashelite — Mon, 14 Mar 2016 05:44:08 GMT

Do you have single select on any of the list box ? and are you using bookmark on top of that ? if so then it will cause this issues ....uncheck the single select on the list box and try again

Re: Result different with IE Plug in vs Web Browser

awhitfield — Mon, 14 Mar 2016 11:51:00 GMT

Hi zagzebski,

you mention triggers above, On Open triggers do NOT work in Ajax unfortunately.

HTH

Andy

Re: Result different with IE Plug in vs Web Browser

mjr6662000 — Sun, 12 Nov 2017 06:59:15 GMT

I also have this problem

result of my app in ajax and IE Plugin is different.

IE plugin is True .

Re: Result different with IE Plug in vs Web Browser

Anonymous — Mon, 19 Nov 2018 06:48:35 GMT

I have the same situation.