topic difference between number days between two date fields in QlikView

difference between number days between two date fields

Tue, 30 Sep 2014 06:39:02 GMT

Hi All,

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

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

Thanks

Re: difference between number days between two date fields

Anonymous — Tue, 30 Sep 2014 07:03:30 GMT

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

Re: difference between number days between two date fields

maxgro — Tue, 30 Sep 2014 07:05:17 GMT

try with

If([VAR ETO] = 'ETO',

Today()-[RDDate],

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

Today()-[GID of RDDdate]

)

Re: difference between number days between two date fields

aveeeeeee7en — Tue, 30 Sep 2014 07:09:13 GMT

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

Re: difference between number days between two date fields

Tue, 30 Sep 2014 07:10:52 GMT

Thank you..looks good