Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
nevilledhamsiri
Specialist
Specialist

Set Expression for the expected output

 

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 NUMBERCLASS B/B/F  PROVISION  PAID  ADJUSTMENT  B/C/F 
RA001A0000025MC                -         600,000     -                       -         600,000
RA001A0000027MC     600,000            150,000       750,000
RA001A0000028MC  1,000,000           (300,000)       700,000
RA001A0000029MC             600,000       600,000
RA001A0000030MC     250,000            300,000       550,000
1 Reply
QFabian
Specialist III
Specialist III

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))

QFabian