Discussion board where members can get started with QlikView.
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?
Great, pl close this thread by marking a correct and any helpful answers
View solution in original post