Chart Title Expression

[#1]

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.

[kaushiknsolanki]

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

[#3]

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.

[kaushiknsolanki]

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

[rwunderlich · Accepted solution]

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