topic Re: Highlighting cases in advance in QlikView

Highlighting cases in advance

nevilledhamsiri — Wed, 02 May 2018 18:11:30 GMT

As per the Debtors Age, I need to highlight cases of which Debtor code='IND' & as & when they get closer to 60 days with a red flag. (If they just pass 56 days, the signal should start to appear so that it will be an eye opener for the deb collector to do the needful. For other codes when they get closer to 105 days, the signal should appear. (As per the system, automatic cancellations will be happened when these two criterians are exceeded. Also at times due to system failure, may be there could be balances being appeared even after exceeding the given restrictions. If those cases are noted they too be reflected being highlighted.

Dear all, please propose me some logical statement to cover this up either in the front end or in a chart.

Thanks in advance

Neville

Re: Highlighting cases in advance

m_woolf — Wed, 02 May 2018 19:41:14 GMT

I changed the Background color expression for the DAYS_FLAG field.

See the attached qvw

Re: Highlighting cases in advance

nevilledhamsiri — Thu, 03 May 2018 00:14:28 GMT

Hi, M W

Could you please send me the expression for each colour since I cannot view your data. (Note I am using a personnel edition)

Thanks a lot.

Re: Highlighting cases in advance

m_woolf — Thu, 03 May 2018 11:51:52 GMT

=if(DEBTOR_CODE='IND' and DAYS_FLAG>=56,lightred(),

if(DAYS_FLAG>=100,lightred()))