Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ravikumar_iyana
Contributor

Make a diffeerence between two date fields

Hi,

I have a two fields NR, IRB.

  1. NR>30 DAYS to IRB Date ,   required resultSmiley Tonguerocessing, Late Payment
  2. NR<30 DAYS to IRB Date ,   required result: on time payment
  3. when  to IRB Date is value: '-' ,    required result: Processing
  4. NR we will calculate based on system date required, entered more than system date required result: entered wrong date

NRIRB
10-Jan-1713-Jan-17
26-Jan-1702-Feb-17
31-jan-1710-feb-17
20-feb-175-apr-17
5-feb-17-
10-mar-175-jun-17
5-apr-17-

Advance Thanks,

Ravi.

3 Replies

Re: Make a diffeerence between two date fields

May be this

If(IRB = '-', 'Processing',

     If(IRB - NR < 30, 'Processing', 'Late Payment'))

YoussefBelloum
Esteemed Contributor

Re: Make a diffeerence between two date fields

Hi,

here in your table, IRB is always > to NR dates..

so maybe change the condition of 1 to this:

  1. IRB>30 DAYS to NR Date ,   required result: Late Payment

I'm I wrong ?

mwoolf
Honored Contributor II

Re: Make a diffeerence between two date fields

if(isnull(ISB),'Processing',

     if(IRB-NR<=30,'Processing','Late Payment')) as Whatever

Community Browser