Set Expression for the expected output

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I need a set expression to be written for the last record (RA001A0000030). This is how it was possible on a simple if statement such as ......IF([B/B/F]<500000 AND [B/B/F]+ADJUSTMENT>500000,[B/B/F]+ADJUSTMENT-500000)). Any idea please?

Thanks

Neville

CLAIM NUMBER	CLASS	B/B/F	PROVISION	PAID	ADJUSTMENT	B/C/F
RA001A0000025	MC	-	600,000	-	-	600,000
RA001A0000027	MC	600,000			150,000	750,000
RA001A0000028	MC	1,000,000			(300,000)	700,000
RA001A0000029	MC				600,000	600,000
RA001A0000030	MC	250,000			300,000	550,000

Re: Set Expression for the expected output

QFabian — Thu, 19 Nov 2020 02:21:58 GMT

Hello @nevilledhamsiri , i tried yor qvw, and this expression works fine, please try it :

if(column(1) < 500000 and (column(1)+column(3))>500000,(column(1)+column(3)-500000))

topic Set Expression for the expected output in QlikView

Set Expression for the expected output

Re: Set Expression for the expected output