Discussion board where members can get started with Qlik Sense.
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:
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."
You need to add one dimension and one measure
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
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.