topic Inserting Symbol Based on Value in QlikView

Inserting Symbol Based on Value

Wed, 25 Nov 2020 16:16:04 GMT

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.

Thanks in Advance.

Regards,

Pooja

Re: Inserting Symbol Based on Value

sunny_talwar — Mon, 23 May 2016 19:59:01 GMT

Check it out

Expressions

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

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

Re: Inserting Symbol Based on Value

Tue, 24 May 2016 01:58:02 GMT

Hi Sunny,

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

Regards,

Pooja