Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hi team

HI Team
could anyone help me..

Name

Sort order

Sales Amount

Symbol

Mike

3

13000

$

Jim

3

400

Robert

3

200

James

4

16000

Robert

4

700

Jack

5

14000

Kevin

5

1000

Description of the issue:

  1. 1.       Name
  2. 2.       Sort Order
  3. 3.       Sales Amount

We want to add a dollar symbol “$” sign at the 13,000 as it is the highest amount in the lowest sort order #



how can I do this??

1 Solution

Accepted Solutions
sunny_talwar

You can try this expression in the straight table:

=If(SortOrder = Min(TOTAL SortOrder) and [Sales Amount] = Max(TOTAL <SortOrder>[Sales Amount]), '$')

Dimension

Name

SortOrder

Or script option:

1)

Table:

LOAD Name,

    SortOrder,

    [Sales Amount]

FROM

[Book1 (8).xlsx]

(ooxml, embedded labels, table is Sheet2);

Left Join (Table)

LOAD *

Where RecNo() = 1;

LOAD SortOrder,

  Max([Sales Amount]) as [Sales Amount],

  '$' as Symbol

Resident Table

Group By SortOrder

Order By SortOrder;

2)

Table:

LOAD Name,

    SortOrder,

    [Sales Amount]

FROM

[Book1 (8).xlsx]

(ooxml, embedded labels, table is Sheet2);

FinalTable:

LOAD *,

  If(RowNo() = 1, '$') as Symbol

Resident Table

Order By SortOrder, [Sales Amount] desc;

DROP Table Table;

View solution in original post

4 Replies
sunny_talwar

Didn't we just got this resolved here: Display '$' symbol to only highest sales amount on condition.

Not applicable
Author

I'm not having access to that Community...can you pls provide the solution here

sunny_talwar

You can try this expression in the straight table:

=If(SortOrder = Min(TOTAL SortOrder) and [Sales Amount] = Max(TOTAL <SortOrder>[Sales Amount]), '$')

Dimension

Name

SortOrder

Or script option:

1)

Table:

LOAD Name,

    SortOrder,

    [Sales Amount]

FROM

[Book1 (8).xlsx]

(ooxml, embedded labels, table is Sheet2);

Left Join (Table)

LOAD *

Where RecNo() = 1;

LOAD SortOrder,

  Max([Sales Amount]) as [Sales Amount],

  '$' as Symbol

Resident Table

Group By SortOrder

Order By SortOrder;

2)

Table:

LOAD Name,

    SortOrder,

    [Sales Amount]

FROM

[Book1 (8).xlsx]

(ooxml, embedded labels, table is Sheet2);

FinalTable:

LOAD *,

  If(RowNo() = 1, '$') as Symbol

Resident Table

Order By SortOrder, [Sales Amount] desc;

DROP Table Table;

Not applicable
Author

Thank you very much