topic Re: How to apply conditional formatting on a column where two duplicate vales are noted in QlikView

How to apply conditional formatting on a column where two duplicate vales are noted

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

As per attached qvd under MY column there are two duplicates (818308@2) ,need to highlight them

Thanks

Neville

nevilledhamsiri — Tue, 20 Aug 2019 18:13:37 GMT

Frank_Hartmann — Tue, 20 Aug 2019 18:22:09 GMT

Backgroundexpression for NET CLAIMS:

Aggr(NODISTINCT If(Count({<DESCRIPTION={'NET CLAIM'}>}MONTH_ACT) > 1, LightGray()), MONTH_ACT)

hope this helps

nevilledhamsiri — Tue, 20 Aug 2019 18:29:21 GMT

Thanks a lot

Neville