Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Howto: Is it possible to make dynamic texts?

Is it possible to ie. generate a date (or other formula based text) in the sheet title - or in labels, title, subtitle, footnote of the different charts?

or is there a specific chart that I can position on the sheet to generate a dynamic piece of text

Tags (1)
9 Replies
pabloviera
New Contributor III

Re: Howto: Is it possible to make dynamic texts?

Hello Rickard, I was just tinkering yesterday with the dynamic texts.

I haven't found a way to use it in the sheets title, but it works in the titles of the visualization objects

You can do something like this, adding not only dates but current filters (It's an example):

'Sales through ' & date(max([Your Field]),'DD/MM') & ': '

& if(isnull(GetFieldSelections(Country)),'',' -Country:') & ' ' & GetFieldSelections(Country)

& if(isnull(GetFieldSelections(Store)),'',' -Stores:') & ' ' & GetFieldSelections(Store)

brunobertels
Valued Contributor

Re: Howto: Is it possible to make dynamic texts?

Hi

everywhere you see a function icone :

you can add dynamic text for example :

'number of sale : ' & 'your mesure'

reddys310
Honored Contributor II

Re: Howto: Is it possible to make dynamic texts?

Hi Rickard,

You can generate titles in the a chart title, subtitle and footer areas. Its not possible with the sheet title but I think it can be worked around with a text object.

Not applicable

Re: Howto: Is it possible to make dynamic texts?

Can I do enforced NewLines ?

Not applicable

Re: Howto: Is it possible to make dynamic texts?

Hi,

You can cancatenate your text with chr(13), this will create a new line.

brunobertels
Valued Contributor

Re: Howto: Is it possible to make dynamic texts?

Hi

I don't think so

ogster1974
Honored Contributor II

Re: Howto: Is it possible to make dynamic texts?

As the guys have said where you have an FX symbol the text displayed can be set by expression.  There are currently gaps in the areas that can be set in this way which I've heard Qlik are going to be addressing.

I hope they do as in addition to eh use case you have mentioned I need to be able to localise my chart comments and currently its a bit hit and miss e.g. titles, subtitles, footnotes yes, dimensions, measures, sheet names no.

vinay_hg
Contributor II

Re: Howto: Is it possible to make dynamic texts?

i think it can be archived using text box & variable. u can assign the variable value dynamically same will be displayed on the text box. but question is what is your definition of dynamic data. from where and how u will receive the data and when, where  & how you want to show the data. based on that u can right the logic

reddys310
Honored Contributor II

Re: Howto: Is it possible to make dynamic texts?

Hi Rickard,

You can use expressions like this in the header, footer and subtitle fields for dynamic texts:

'Current View - '&

if(getfieldselections([`Date Status`]) = 'Quarter', 'Quarterly: ' ,

if(getfieldselections([`Date Status`]) = 'Month', 'Monthly' ,

if(getfieldselections([`Date Status`]) = 'Last Week', 'Last Week',

if(getfieldselections([`Date Status`]) = 'Week','Weekly'  ,

'Monthly'

))))

& chr(13)

& if(isnull(getfieldselections([Order Status])), 'New,Used,Motability',getfieldselections([Order Status]))

Community Browser