Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
balajibala
Contributor III
Contributor III

Prev YTD and MTD

I need to compare the current month data for a particular Date with previous month data for same date, If there is no data on the same Date of previous month i have to compare with two days back data (N-2) Date... Can any one help me ..

Kind Regards,
Balaji.R
1 Solution

Accepted Solutions
balajibala
Contributor III
Contributor III
Author

I have sales data for today, i have to compare the previous month sales data with same date, if i doesn't have sold on that day i have to compare with previous day or day before. Date = 15/01/2019 comparing Date= 15/12/2018 If i have no sales on 15/12/2018 , i have to compare with 14/12/2018 or 13/12/2018

Kind Regards,
Balaji.R

View solution in original post

3 Replies
sunny_talwar

Please provide a sample and expected output to help you better here

balajibala
Contributor III
Contributor III
Author

I have sales data for today, i have to compare the previous month sales data with same date, if i doesn't have sold on that day i have to compare with previous day or day before. Date = 15/01/2019 comparing Date= 15/12/2018 If i have no sales on 15/12/2018 , i have to compare with 14/12/2018 or 13/12/2018
Kind Regards,
Balaji.R
balajibala
Contributor III
Contributor III
Author

I have sales data for today, i have to compare the previous month sales data with same date, if i doesn't have sold on that day i have to compare with previous day or day before. Date = 15/01/2019 comparing Date= 15/12/2018 If i have no sales on 15/12/2018 , i have to compare with 14/12/2018 or 13/12/2018

Kind Regards,
Balaji.R