# New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

## Inserting Symbol Based on Value

Hi Firends,

Need Help in Syntax for the below Requirement:

 ID RD1 RD2 1 PT Def ID Amount PT1 Def1 ID Amount1 1 X Finance 1 18000 X Operation 3 9000 5 y Finance 1 250000 y Operation 3 3000 6 Z Finance 5 9000 Z Operation 4 120000 7 w Finance 6 5000 w Operation 4 1000 9 t Finance 7 2000 t Operation 9 3000 The Output for RD1 is: The output for RD2 is: Id Amount Id Amount1 1 \$250,000 3 \$9,000

I need to put \$ symbol in the highest Amount in lowest id.(here we need to write the expression or script based on the 'id' Filed only.Also Have attached the QVW file. Any help would be great.

Regards,

Pooja

1 Solution

Accepted Solutions
MVP

## Re: Inserting Symbol Based on Value

Check it out

Expressions

1)

If(id =Min(TOTAL id) and  Amount = Max(TOTAL <id> Amount), '\$') & Amount

or may be a better one would be this:

If(id = Min(TOTAL {<pt = {'*'}>}id) and  Amount = Max(TOTAL <id> Amount), '\$') & Amount

2)

If(id = Min(TOTAL {<pt1 = {'*'}>}id) and  Amount1 = Max(TOTAL <id> Amount1), '\$') & Amount1

2 Replies
MVP

## Re: Inserting Symbol Based on Value

Check it out

Expressions

1)

If(id =Min(TOTAL id) and  Amount = Max(TOTAL <id> Amount), '\$') & Amount

or may be a better one would be this:

If(id = Min(TOTAL {<pt = {'*'}>}id) and  Amount = Max(TOTAL <id> Amount), '\$') & Amount

2)

If(id = Min(TOTAL {<pt1 = {'*'}>}id) and  Amount1 = Max(TOTAL <id> Amount1), '\$') & Amount1

Not applicable

## Re: Inserting Symbol Based on Value

Hi Sunny,

Thank you so much. It's working as expected.

Regards,

Pooja