Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
sangeetha_changu
New Contributor

highlight the entire row if there are duplicates in dimension

Approval No_9digit is extracted from Approval No. 

If the Approval No_9digit is same and repeating, need to highlight the entire row

Attached screenshot

 
4 Replies
Highlighted
Partner
Partner

Re: highlight the entire row if there are duplicates in dimension

Hi,

You can try using If & Previous.

If(ApprovalNo_9digit = Previous(ApprovalNo_9digit), Yellow())

(Sort data on DepotDate)

 

Thanks,

Ashutosh

sangeetha_changu
New Contributor

Re: highlight the entire row if there are duplicates in dimension

this didn't work

Highlighted
Frank_Hartmann
Honored Contributor II

Re: highlight the entire row if there are duplicates in dimension

maybe this expression:

if(count( Total <[Approval No_9digit]> [Approval No_9digit]) > 1 , LightGreen())

or

Aggr(NODISTINCT If(count([Approval No_9digit]) > 1, LightGreen()), [Approval No_9digit])

Highlighted
sangeetha_changu
New Contributor

Re: highlight the entire row if there are duplicates in dimension

this didnt help

kpi3_3.PNG