3 Replies Latest reply: Jan 26, 2017 8:24 PM by Dennis Rookwood RSS

    Customizing Dimensions

    Dennis Rookwood

      Hello, new to Qlik here.

       

      I'd like to build a custom Dimension.  My field, is "Departments" , within the field I have several variables, Sales, Operations, Finance, etc.

       

      I try to use:

       

      Sum(Department[Sales])

       

      But that does not work.

       

      If I don't select the department, and I create a measure, it will aggregate everything in the field "Departments."

       

      Thanks!

        • Re: Customizing Dimensions
          Sunny Talwar

          You need to add one dimension and one measure

           

          Dimension

          Department

           

          Measure

          Sum(Sales)

          • Re: Customizing Dimensions
            Oleg Troyansky

            Hi Dennis,

             

            I think you are a bit confused with the terminology - Dimensions, Variables, Measures, etc... Why don't you explain in plain English what are you trying to accomplish?

             

            If you need a chart of Sales by Department, then simply select Department as a Dimension and sum(Sales) as the Measure. Is your problem more complex than that?

             

            cheers,

            Oleg Troyansky

            Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Munich, Germany!

              • Re: Customizing Dimensions
                Dennis Rookwood

                I'd like to create a bar chart that will show only the expenses for sales for the months Jan-April

                 

                 

                DepartmentExpensesMonth
                Sales10January
                Sales43Feb
                Sales4March
                Sales6April
                Marketing34January
                Marketing6Feb
                Marketing23March
                Marketing43April

                 

                Currently I have to create a filter pane with the dimension "Department" so I can filter on departments.

                 

                I would like to make a custom measure that takes the sum of Sales, without using the filter pain.