Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Previous Date

Dear Community,

I would like to get the previous date information, instead of date - 1, anyone has idea on this?

perhaps some simple functions...

Sample attachment:

I would like to see 6/3/2014 in PrevDate column, instead of 6/4/2014 as yellow highlighted below.

Thanks,

Chanel

1 Solution

Accepted Solutions
satyadev_j
Valued Contributor

Re: Previous Date

Hi,

Try "Previous(Date) as PrevDate" instead of "Date - 1 as PrevDate"

2 Replies
satyadev_j
Valued Contributor

Re: Previous Date

Hi,

Try "Previous(Date) as PrevDate" instead of "Date - 1 as PrevDate"

Re: Previous Date

Hi,

May be like this look at the attached.

Regards

ASHFAQ

Community Browser