topic Re: Color is not changing on Access Point in QlikView

Color is not changing on Access Point

preetipandey1 — Mon, 01 Aug 2016 06:07:02 GMT

Hi All,

I have developed one dashboard where I have implemented one highlight box. I am changing the color of that text box on even and odd second. When I am opening dashboard on qlikview developer, color is changing but when I am opening same application using access point URL color is not changing.

Please find expression which I am using to change color:

=if(Odd(Second(now(1))),RGB(202,202,202),RGB(240,0,0))

Please help to resolve this issue.

Thanks

Re: Color is not changing on Access Point

Anil_Babu_Samineni — Mon, 01 Aug 2016 08:26:36 GMT

Your file is working on my Access point.

Re: Color is not changing on Access Point

preetipandey1 — Mon, 01 Aug 2016 08:30:34 GMT

Hi Anil,

Do you know what will be the reason, the same functionality is not working on my access point.

Do I need to change any setting.

Thanks

Preeti

Re: Color is not changing on Access Point

Anil_Babu_Samineni — Mon, 01 Aug 2016 08:53:05 GMT

No, Nothing to change. In fact, I just upload this file into My Access point. It is working? Can you please share me your Picture?

Re: Color is not changing on Access Point

Chanty4u — Mon, 01 Aug 2016 08:58:22 GMT

try to upgrde ur browser. orelse try to restrt ur system and try once.

Re: Color is not changing on Access Point

Colin-Albert — Mon, 01 Aug 2016 08:58:40 GMT

Are you using the IE Plugin or Ajax client?

Re: Color is not changing on Access Point

Colin-Albert — Mon, 01 Aug 2016 09:04:01 GMT

If you are using Ajax, you may need to use this extension.

This is designed for scorecard type dashboards that automatically refresh on a large screen with no user intervention.

http://www.qlikblog.at/2779/qlikview-autorefresh-document-extension/

Re: Color is not changing on Access Point

beck_bakytbek — Mon, 01 Aug 2016 09:06:40 GMT

Hi Pandey,

try to activate IE Plugin,

beck

Re: Color is not changing on Access Point

preetipandey1 — Mon, 01 Aug 2016 10:36:43 GMT

Thanks Beck and Colin,

By using IE Plugin I am getting the desired result, only thing is that I have to click the Clear All button every time I launch the application on access point. Can we avoid this?

Preeti

Re: Color is not changing on Access Point

Colin-Albert — Mon, 01 Aug 2016 10:44:40 GMT

Be aware that changing from Ajax to the IE Plugin will loose some functions:

Extensions are not supported with the Plugin.
The plugin must be installed on each user's machine, and uninstalled and re-installed whenever the server is upgraded.
The Plugin only supports Internet Explorer, whereas the Ajax client supports other browsers as well.
The IE Plugin does not support collaboration & annotation of documents
The IE Plugin does not support session sharing.

There is a list of differences here IE Plugin Vs Ajax Client

Re: Color is not changing on Access Point

Colin-Albert — Mon, 01 Aug 2016 10:59:18 GMT

You are using Now(1) this will poll the OS every second and may degrade performance.

Your call if this is worth it just to make a text box flash.

The warning below is from the QV help on the now() function.

The timer_mode = 1 should be used with caution, since it polls the operating system every second and hence could slow down the system