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?
Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Munich, Germany!
I'd like to create a bar chart that will show only the expenses for sales for the months Jan-April
Department Expenses Month Sales 10 January Sales 43 Feb Sales 4 March Sales 6 April Marketing 34 January Marketing 6 Feb Marketing 23 March Marketing 43 April
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.