topic Re: Qlikview - document title with functions doesn't works in QlikView

Qlikview - document title with functions doesn't works

agigliotti — Fri, 24 Nov 2017 08:39:24 GMT

Hello,

I noted right now the document title doesn't works using functions as below:

I think it's not working as expected.

Did someone face the same issue ?

Thanks in advance.

Best Regards

Andrea

Re: Qlikview - document title with functions doesn't works

felipedl — Fri, 24 Nov 2017 10:45:17 GMT

Hi Andrea,

What are you getting with what you showed?

Might be a version related issue, but I tested on version 11.20 SR3 and works fine.

Felipe.

Re: Qlikview - document title with functions doesn't works

agigliotti — Fri, 24 Nov 2017 10:56:30 GMT

yes what you showed me works fine also for me.

I means "Title" under Document Properties.

Re: Qlikview - document title with functions doesn't works

felipedl — Fri, 24 Nov 2017 14:54:26 GMT

My mistake Andrea,

It seems that the document title only accepts string, not functions, just tested it out.

I've tried it here now with the document properties and get the same result as you do.

Re: Qlikview - document title with functions doesn't works

ashfaq_haseeb — Mon, 27 Nov 2017 10:52:25 GMT

Hi,

I think this is broken feature in Qlikview.

But there are ways around to make this functional.

You have to use a macro for this.

You can set the document title using a macro, variable, and a trigger.

1) Add the following macro to your document:

SUB SetDocumentTitle()

set dp = ActiveDocument.GetProperties

set v = ActiveDocument.Variables("vDocumentTitle")

dp.WindowTitle = v.GetContent.String

ActiveDocument.SetProperties dp

END SUB

2) Add a variable vDocumentTitle.

Ex: vDocumentTitle=today()

3) Add a document event trigger with an external action "Run Macro" and run the macro SetDocumentTitle.

May be you can add trigger OnOpen event.

This is a bit tricky you have to try multiple events here.

Not all macros will work in Ajax. you have to use IE Pluggin, but give it a try.

Hope it helps.

Regards

ASHFAQ

Re: Qlikview - document title with functions doesn't works

agigliotti — Fri, 29 Dec 2017 08:55:44 GMT

it's still a broken feature in latest version November 2017 SR1.

i hope qlik's guys will fix it soon.

Andrea