Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with document refresh

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

5 Replies
kaushiknsolanki
Luminary Alumni
Luminary Alumni

HI,

   What do you mean by element.

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
pkelly
Specialist
Specialist

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

Not applicable
Author

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

View solution in original post

Miguel_Angel_Baeyens

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

Not applicable
Author

Thanks Miguel,

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