Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Customizing Dimensions

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!

3 Replies

Re: Customizing Dimensions

You need to add one dimension and one measure

Dimension

Department

Measure

Sum(Sales)

MVP & Luminary
MVP & Luminary

Re: Customizing Dimensions

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!

Not applicable

Re: Customizing Dimensions

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.