Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

Qliksense UI help

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!!

14 Replies
jaumecf23
Creator III
Creator III

Hi,

Introduce the following formula in the "Title Expression" box in the Sheet Propiertes:

=ReloadTime()

jwjackso
Specialist III
Specialist III

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

jschrader
Contributor III
Contributor III

I am on the February release for Qlik Sense.

SheetTitle.PNG

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?

jwjackso
Specialist III
Specialist III

Can you show how you define the vFFValue?

arusanah
Creator II
Creator II
Author

it just returns text. expression i', using is

='Summary'&ReloadTime()

arusanah
Creator II
Creator II
Author

this also displays just text ;

vDate= today()-1

arusanah
Creator II
Creator II
Author

where is the fx() box ? all I see is these options.

and when I enter =ReloadTime() . it just returns text,

arusanah
Creator II
Creator II
Author

I need it on SHEET TITLE bar and not the object bar

jwjackso
Specialist III
Specialist III

QlikSenseFunction.PNG

The first is just text, the second is a data item and executes the Reloadtime() function.