4 Replies Latest reply: Jan 7, 2013 2:35 AM by Mohit Sharma RSS

    selection and dimension

    Jive Admin

      Hello,

      I am new to qlikview ,while reading the documentaion on set analysis I am confused what is the difference between a selection and dimension

      in the below context:

      sum({1} Sales) 

      Returns total sales within the application, "disregarding selections but not

      the dimension."

       

      Thanks for patience.

        • Re: selection and dimension
          Vishwaranjan Kumar

          hi

          actually dimension means, on which basis you perfor the calculation.

          and selection means on the selection do this work.

          example

          If I've understood what you want, you do it like this:

           

          sum(total Sales)

           

          The "total" keyword tells QlikView to disregard all dimension values.  If you need to include some but not all of the dimensions, you list the dimensions you want to include:

           

          sum(total <Year, Customer> Sales)

          • Re: selection and dimension
            Mohit Sharma

            in set analysis 1 means selection based on all

            and you shuld try $ sign instead of 1..

            then your answer must be based on selection

            hope it helps

            • Re: selection and dimension
              Kabilan Kumarasamy

              Hi,

               

              We have expression  and dimension in chart ryt?

               

              Dimension like  EmpName

                                       EmpNO

              Expression like Sum({1}Salary)

               

              Here we have list box Called EmpName,EmpNO, So If we Select any one data from these List box data are reflected to the Chart. Because these two are dimension of the chart

               

              And we have department listbox(Selection), So if we Select any one data from that List box data are not reflected to the chart. because this is a just selection box. if it may be a dimension of chart the Data will reflect.

               

              I hope, it helps U...

               

              Regards,

              Kabilan K