Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

difference between number days between two date fields


Hi All,

  is this if else condition is fine??I do not get any value,getting blank,any suggestions

 

If

([VAR ETO] = 'ETO',
Today()-'RDDate',If([Item Category]='ZSPK' or 'ZSK1',today()-'GID of FPDdate',Today()-'GID of RDDdate'))

Thanks

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

it looks like there are strings when there should be fields?

If ([VAR ETO] = 'ETO',
Today()-RDDate,If([Item Category]='ZSPK' or [Item Category]= 'ZSK1',today()-[GID of FPDdate],Today()-[GID of RDDdate]))

hope this helps.

Best regards

Stefan

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Hi,

it looks like there are strings when there should be fields?

If ([VAR ETO] = 'ETO',
Today()-RDDate,If([Item Category]='ZSPK' or [Item Category]= 'ZSK1',today()-[GID of FPDdate],Today()-[GID of RDDdate]))

hope this helps.

Best regards

Stefan

maxgro
MVP
MVP

try with

=

If([VAR ETO] = 'ETO',

     Today()-[RDDate],

     If(     match([RDDate], 'ZSPK', 'ZSK1'), today()-[GID of FPDdate],

             Today()-[GID of RDDdate]

     )

)

aveeeeeee7en
Specialist III
Specialist III

Try this:

If([VAR ETO] ='ETO',Num(Today())-Num(RDDate),

If(Match([Item Category],'ZSPK','ZSK1'),Num(today())-Num(GID of FPDdate),Num(Today())-Num(GID of RDDdate)))

Regards

Av7eN

Not applicable
Author

Thank you..looks good