qlikview expression value is blank on open. Shows values after fresh

[Anonymous]

Hi,

I have an expression with FieldValue function.

The values are blank when I open the dashboard. However when I refresh it the values show up.

Anyone knows a solution to fix it?

Bharath.

Attached the qlikview and source data excel files. Hope this helps.

[vishsaggi]

Where are you using this function? Can you send some more information on this?

[Sergey_Shuklin]

Hello, Bharath!

This issue can appear occasionally if you use a lot of objects. I heard removing rarely used objects (or even objects in temporary Sheets) can help to solve the issue. So, look for way of reducing objects. I think it will help!

[tajmohamed30]

you can reload on open to display the values, follow the steps in the link below

Auto reload on open

hope it helps

[Anonymous]

I have only one straight table in the sheet.

I tried the "reload on open" and that didnt work either.

Something wierd is happening.

[tajmohamed30]

have you tried creating new document similar to the one where you have some problem and check whether it is coming without any issues

[Sergey_Shuklin]

Hm, I've opened you project several times and values are there. Can you open it in other computer?

[tajmohamed30]

yes please

[Anonymous]

I tried. This is what I see when I open the dashboard. Is there any settings/preferences that I need to change?

[tajmohamed30]

Please have a look attached document, I have enabled macro to reload on open

Regards

Taj Mohamed