Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Top 10 sales in text and Gauge

Hi all

I'm currently making a performance dashboard for our Sales department, and for that reason I'm trying to make a top 10 chart of sales people.

There is already a lot of other people who have asked similar questions, however I haven't been able to find the answer for my little project

What I'm trying to is to have 10 text boxes and 10 gauge charts, where each pair is showing 1 of the top 10 salespersons.

Please se attached example.

Is that possible?

Regards

Stefan

1 Solution

Accepted Solutions
Highlighted

19 Replies
Highlighted
Specialist III
Specialist III

I can't open your .qvw because i'am on personnal edition, but try with

Text box with the name of sales people:

Number 1=FirstSortedValue(Sales people, -sales,1)

Number 2=FirstSortedValue(Sales people, -sales,2)

Gauge chart with the sales amount:

Number 1=Max(Sales)

Number2= Max(Sales,2)

Highlighted
Master III
Master III

Hi Stefan,

see Attachment.

Regards,

Antonio.

Highlighted
Creator
Creator

Hi Jean-Baptiste

Thanks for your answer

The textbox would work if it was that simple, but the gauge doesn't work with Rank 2.

The sample is really simplistic. Meaning in the main file the sum of sales will have some limitations. Some set expression.

So in the mail file it would be something like this  FirstSortedValue(Sales people, Sum( {< Region = {'1}' >} -sales),1)


and then it doesn't work.

Highlighted
Specialist III
Specialist III

Try with:

FirstSortedValue(Sales people, - Sum( {< Region = {'1'} >} sales),1)

Highlighted
Creator
Creator

Hi Antonio

That's really nice Seems to the job.

I've attached a new sample where budget (C) is included, can you make the expression so it includes that instead of total sales?

Regards

Stefan

Highlighted
Master III
Master III

In my Doc You can add Set Analysis directly in FirstSortedValue() and Max() functions, like

FistSortedValue({< Region = {'1}' >} A,-Aggr(Sum({< Region = {'1}' >} B),A))

Max({< Region = {'1}' >} ..........

Highlighted

So you want to use Field C instead of Field B?

Highlighted
Creator
Creator

Yes like below.

However I want something like this:

=Num(Max(TOTAL Aggr(Sum(B),A),2) /Aggr(Sum(B), A),'#0,0 %')

To ensure that calculated share is based individual sales and budget.

Udklip.JPG

Highlighted

This expression

=Num(Max(TOTAL Aggr(Sum(B),A),2) /Aggr(Sum(B), A),'#0,0 %')

is different from your image that you just posted...

Capture.PNG

Not 100% sure what you are looking to get... May be Antonio might now better since he has been working with this thread....