Discussion Board for collaboration related to QlikView App Development.
Approval No_9digit is extracted from Approval No.
If the Approval No_9digit is same and repeating, need to highlight the entire row
You can try using If & Previous.
If(ApprovalNo_9digit = Previous(ApprovalNo_9digit), Yellow())
(Sort data on DepotDate)
this didn't work
maybe this expression:
if(count( Total <[Approval No_9digit]> [Approval No_9digit]) > 1 , LightGreen())
Aggr(NODISTINCT If(count([Approval No_9digit]) > 1, LightGreen()), [Approval No_9digit])
this didnt help