Qlik Community

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:

     

IDRD1 RD2
1PTDefIDAmountPT1Def1IDAmount1
1XFinance118000XOperation39000
5yFinance1250000yOperation33000
6ZFinance59000ZOperation4120000
7wFinance65000wOperation41000
9tFinance72000tOperation93000
The Output for RD1 is:The output for RD2 is:
IdAmountIdAmount1
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.

Thanks in Advance.

Regards,

Pooja

1 Solution

Accepted Solutions

Re: Inserting Symbol Based on Value

Check it out

Capture.PNG

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

View solution in original post

2 Replies

Re: Inserting Symbol Based on Value

Check it out

Capture.PNG

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

View solution in original post

Not applicable

Re: Inserting Symbol Based on Value

Hi Sunny,

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

Regards,

Pooja