topic Re: Qliksense UI help in App Development

Qliksense UI help

arusanah — Thu, 07 Jun 2018 13:23:37 GMT

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

Re: Qliksense UI help

jaumecf23 — Thu, 07 Jun 2018 14:18:28 GMT

Hi,

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

=ReloadTime()

Re: Qliksense UI help

jwjackso — Thu, 07 Jun 2018 14:19:11 GMT

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

Re: Qliksense UI help

jschrader — Thu, 07 Jun 2018 14:49:15 GMT

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?

Re: Qliksense UI help

jwjackso — Thu, 07 Jun 2018 14:52:06 GMT

Can you show how you define the vFFValue?

Re: Qliksense UI help

arusanah — Thu, 07 Jun 2018 15:00:24 GMT

it just returns text. expression i', using is

='Summary'&ReloadTime()

Re: Qliksense UI help

arusanah — Thu, 07 Jun 2018 15:02:09 GMT

this also displays just text ;

vDate= today()-1

Re: Qliksense UI help

arusanah — Thu, 07 Jun 2018 15:15:39 GMT

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

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

Re: Qliksense UI help

arusanah — Thu, 07 Jun 2018 15:17:43 GMT

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

Re: Qliksense UI help

jwjackso — Thu, 07 Jun 2018 15:22:36 GMT

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

Re: Qliksense UI help

jschrader — Thu, 07 Jun 2018 15:33:23 GMT

For small applications, I do let vVariable = today() in the load script. Then, I call the variable in Qlik Sense. For larger applications with a staging process, I do let vMaxDate = today() in stage one. Then, I create a inline table

ReloadTable:

Load * Inline [

ID, Value

1, '$(vMaxDate)'

]

;

store * from ReloadTable into [file path]

Then, in the stage 3 application I load the table and do a peek function to set the reload variable

let vMaxDate = peek('MaxDate',-1,'Reload');

Re: Qliksense UI help

jschrader — Thu, 07 Jun 2018 15:34:18 GMT

Which version of Qlik Sense are you using?

Re: Qliksense UI help

arusanah — Thu, 07 Jun 2018 15:35:05 GMT

Hi Jerry ,

I already am using it in text object. But what I was trying to see is if we can get it on " MY New Sheet " - bar . just trying to see if I can save some space in real estate and use it for something else .

Re: Qliksense UI help

jschrader — Thu, 07 Jun 2018 15:45:57 GMT

I am on the February 2018 release of Qlik Sense. If you are on an older version of Qlik Sense, then you will need to upgrade to get the fx in chart title. I do not remember when, but I believe there was a time when you could not use formulas to rename the sheet title.

Re: Qliksense UI help

premvihari — Fri, 08 Jun 2018 05:59:45 GMT

Goto sheet properties
and in title expression try as below

='XXXX as on '&Reloadtime()