Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (1)
1 Solution

Accepted Solutions
s_kunte23
Contributor III

Re: difference between number days between two date fields

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

4 Replies
s_kunte23
Contributor III

Re: difference between number days between two date fields

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

MVP
MVP

Re: difference between number days between two date fields

try with

=

If([VAR ETO] = 'ETO',

     Today()-[RDDate],

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

             Today()-[GID of RDDdate]

     )

)

aveeeeeee7en
Valued Contributor III

Re: difference between number days between two date fields

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

Re: difference between number days between two date fields

Thank you..looks good

Community Browser