topic Problem with document refresh in QlikView

Problem with document refresh

Wed, 06 Jul 2011 07:40:37 GMT

Hi all,

I have a problem with one report. It refreshes all the time.

When i want to navigate in a table for example with the scroll bar, the scroll comes back to its initial position.

If I publish the report on our web server, all the elements refresh every second.

Can anybody help me please???

Thx 😉

Greg

Problem with document refresh

kaushiknsolanki — Wed, 06 Jul 2011 07:42:40 GMT

HI,

What do you mean by element.

Are you using Now() Function in calculation...?

Regards,

Kaushik Solanki

Problem with document refresh

pkelly — Wed, 06 Jul 2011 07:47:13 GMT

I am possibly miles out with this suggestion but...

On the layout tab you will find a "Preserve Scroll Position" tick box.

If you tick this it may stop the scroll bar returning...

Regards

Paul

Problem with document refresh

Wed, 06 Jul 2011 10:02:21 GMT

Hi All,

I found the solution and effectively, the responsible was the function Now().

I used this function on the "OnActivate" trigger of my sheet in order to put the current year as default value in a field.

As the function Now() changes every second, my sheet refreshed...

Thanks for your help Kaushik and Paul ;-))

Problem with document refresh

Miguel_Angel_Baeyens — Wed, 06 Jul 2011 10:08:29 GMT

Hello Grégory,

Note that Now() accepts parameters, Now(0) refers to the load script execution time and Now(2) shows when the document was opened, and in both cases the function does not "refresh". Now(1) is the default, and refreses every second.

Apart from that, you can create a variable in the script that stores the current year and refer to this value later in run time.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Problem with document refresh

Thu, 07 Jul 2011 12:39:23 GMT

Thanks Miguel,

it's exactly what I've done abnd it work perfectly 😉