4 Replies Latest reply: Aug 10, 2011 3:29 AM by Rob Wunderlich RSS

    Chart Title Expression

      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
          Kaushik Solanki

          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

              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
                  Kaushik Solanki

                  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
                    Rob Wunderlich

                    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