Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
razyorazyo
New Contributor II

CALCULATE DATE

Hi

I have field which its type is AlphaNumeri and contains date of the following format :20180424.

2018 - year

04 - month

24 - day

I need to relate each date to right week of the year and I do it with interval match command.

now ,I need , for each date ,to calculate the date 7 days before and then relate  it to the correct week.

how can I calculate the new date without changing its format or calculate and converting the new date to the original format?

Thanks

Raz

1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: CALCULATE DATE

Great, pl close this thread by marking a correct and any helpful answers

View solution in original post

3 Replies
Highlighted
sasiparupudi1
Honored Contributor III

Re: CALCULATE DATE

Date(Date#(20180424,'YYYYMMDD')+7,'YYYYMMDD')

Highlighted
razyorazyo
New Contributor II

Re: CALCULATE DATE

Great.

its working.

Thanks

sasiparupudi1
Honored Contributor III

Re: CALCULATE DATE

Great, pl close this thread by marking a correct and any helpful answers

View solution in original post