Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qliker's,
I have a requirement to show data refresh date on "SHEET TITLE BAR". I tried getting reload date in variable and display it with sheet title but it shows variable name and not the value.
so I wanted to know is it possible to get Reload() work on Sheet Title bar ? if yes , then please let me how . I would appreciate!!
Hi,
Introduce the following formula in the "Title Expression" box in the Sheet Propiertes:
=ReloadTime()
Is there a reason you are assigning the function to a variable. Why not add the below statement to the sheet "Title expression" or Description.
='Data Refreshed On '&ReloadTime()
I am on the February release for Qlik Sense.
The value in my variable is 1. the Title on the Sheet is 'Sheet 1'
Is this what you want to do? Do you mean something else?
Can you show how you define the vFFValue?
it just returns text. expression i', using is
='Summary'&ReloadTime()
this also displays just text ;
vDate= today()-1
where is the fx() box ? all I see is these options.
and when I enter =ReloadTime() . it just returns text,
I need it on SHEET TITLE bar and not the object bar
The first is just text, the second is a data item and executes the Reloadtime() function.