topic Re: Hi team in QlikView

Hi team

Wed, 25 Nov 2020 16:16:04 GMT

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. Name
2. Sort Order
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??

Re: Hi team

sunny_talwar — Fri, 22 Apr 2016 20:01:02 GMT

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

Re: Hi team

Fri, 22 Apr 2016 20:02:47 GMT

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

Re: Hi team

sunny_talwar — Fri, 22 Apr 2016 20:04:40 GMT

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:

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;

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;

Re: Hi team

Fri, 22 Apr 2016 20:20:51 GMT

Thank you very much