Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Using a calculated dimension...

This is the first question I have posted so hopefully I can make it clear.

I have one big table of individual sales, with amongst other things, value of sale and the EmplyeeNo of the person who made the sale.

I want to draw a bar-chart that shows the number of employees who sold different amounts.

So the dimension of the bar chart would be something like:

Round to the nearest 100 ( Sum ( [for each EmployeeNo] SalesValue))

And the expression would be:

Count (Distinct EmployeeNo)

ie I want to look at the distribution of total sales per employee.

But I can't figure out how to write the dimension. I have made lots of attempts along the lines of

 

Sum(Total <DISTINCT EmployeeNo> SaleAmount )

But they all return errors...

Any help would be much appreciated

3 Replies
Not applicable

Re: Using a calculated dimension...

Please see the attached QV application

Reagrds

Mhatim

Not applicable

Re: Using a calculated dimension...

Sorry but that's not what I was looking for.

I know how to have two axes, one on the left and one on the right.

I want the rounded sales amount on the x-axis with a bar for each amount (not for each employee) and then the height of the bar to reflect the count of employees

Not applicable

Re: Using a calculated dimension...

Not sure if this helps.

Please see the attached QV application

Community Browser