topic Chart Title Expression in QlikView

Chart Title Expression

Wed, 10 Aug 2011 06:11:48 GMT

Dear All Friends,

In a demo application named 'Online Sales' I found expressions in Chart Title Text Field.

On the first sheet named 'Dashboard' there are many objects.One of them is Profit Margin

Gauge Chart.In that Gauge Chart Properties->General Tab->There is a 'Show Title in Chart'

Check Box and Text Field.On the text field "= Only({<No={14}>} [$(=vDataLanguage)])" that

expression is written.

I want to know how the expression is working.From where the No=14 comes?

Please guide me friends.

I am attaching the application for your reference.

Thanks And Regards,

Koushik Roy.

09434343030.

Chart Title Expression

kaushiknsolanki — Wed, 10 Aug 2011 06:19:50 GMT

Hi,

I dont have Qlikview Installed on my laptop, so i am unable to see the atachment, but i can tell you what the expression is.

The expression is "= Only({<No={14}>} [$(=vDataLanguage)])"

Here variable is used. i.e vDataLanguage, so as name suggest it may contain the Language.

So the expression says that select the language where the No is 14.

Here No might be a Field.

For more understanding. Create a Listbox for No field. and also have a look at the Variable (Meaning what it Contents) and try to place it in expression and compare the result.

Regards,

Kaushik Solanki

Chart Title Expression

Wed, 10 Aug 2011 06:35:53 GMT

Dear Kaushik,

Thank you very much for your reply.Let me clear one more thing,where the Language codes are stored?

Are they stored in a table or the developer scripted it?I can not find that details where the languge are stored.

Thanks for your answer again Kaushik.

Thanks & Regards,

Koushik Roy.

Mob:-9434343030.

Chart Title Expression

kaushiknsolanki — Wed, 10 Aug 2011 06:51:56 GMT

Hi,

As i said i cant open the file.

So can you please tell me what is the value and the expression in variable vDataLanguage

For this you should look into Variable Overview in Setting.

Regards,

Kaushik Solanki

Chart Title Expression

rwunderlich — Wed, 10 Aug 2011 07:29:25 GMT

The titles are loaded from a spreadsheet into QV table "Translations". The No={14} selects a key in this table that identifies the text that should be used for this this chart title. The $(=vDataLanguage) narrows the selection to the Language field currently selected by the user in the upper right of the sheet.

So the Translations table contains a field "No", and a seperate field for each of the four languages this document supports.

-Rob