How to display top 3 Contract Names when same contract names are there?

[srinivas1921]

Hi,

one of our requirement is need to display top 3 contract Names based on amount value in the Bar chart.But when I trying to display top 3 contract Names it was showing wrong values due to grouped by Contract Name.

Please see below tables and suggest me solution on this to expected results.

Actual Data:-

Contract Number	Contract Name	Amount
121	AAA	100
122	BBB	50
123	AAA	62
124	CCC	55
125	DDD	80

showing output in the Bar Chart as below:-

Contract Name	Amount
AAA	162
DDD	80
CCC	55

Expected Output as below:-

Contract Name	Amount
AAA	100
DDD	80
AAA	62

[srinivas1921]

Hi Sunny,

your solution working fine but in my bar chart displaying two dimensions like parent contract name and calculated dimesion. I want to display only Parent contract name only.please suggest.

[sunny_talwar · Accepted solution]

Try this script:

Table:

LOAD Dual([Contract Name], AutoNumber([Contract Number]&[Contract Name])) as [Dim Contract Name],

  [Contract Number],

    [Contract Name],

    Amount

FROM

[https://community.qlik.com/thread/233795]

(html, codepage is 1252, embedded labels, table is @1);

Bar Chart

Dimension

[Dim Contract Name]

Expression

=Sum({<[Dim Contract Name] = {"=Rank(Sum(Amount)) < 4"}>}Amount)

[miguelbraga]

Hey there,

You want something like this?

Please see the attached file

Best regards,

D.A. MB

[miguelbraga]

Even better now

Best regards,

D.A. MB

[srinivas1921]

Thank u very much Sunny