2 Replies Latest reply: Apr 2, 2012 8:39 AM by jagan mohan rao appala RSS

    Variable For Dummies

      Hi guys,

       

      I would like to seek help if there is a specific documentation on how to use variables and when to use it? I'm kinda new in QlikView and i'm having challenges understanding variables. I know how to create a variable but I can't get the idea on how and when to use it.

        • Re: Variable For Dummies

          Hi,

           

          there are thousands of ways to use a variable. I'll give two examples to get you started.

          Theme: when using, custom, colors it's quite a job to manually change all objects. Instead - define a variable to hold your color definition and you only need to change that to affect all objects:

           

          SET vColor9                    = 'RGB(221,238,252)';          //Light blue
          
          Then use with $ expansion in calculated color $(vColor9)
          

           

          Navigation:

          Lets asume you have a chart that should only show if certain conditions are met. A home made tab perhaps. Then you assign a varable the tab value and set a show condition for the chart.

          • Re: Variable For Dummies
            jagan mohan rao appala

            Hi,

             

            Check the Set Analysis section, it has examples of using variables in Set Analysis expressions.

             

            Hope the below URL also helps you.

             

            http://www.quickqlearqool.nl/?p=902

             

            Regards,

            Jagan.