Discussion Board for collaboration related to QlikView App Development.
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?
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))