Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Day to day comparision

Hi,

I need to compare sum(sales) for current day vs last year same day.

Ex: Today is Friday ,second week of march 3/10/2017 with this date sales i need to compare last year Friday ,second week of march 3/11/2016.

Thanks..

4 Replies
muthukumar77
Partner
Partner

Try like this,

Current Year Date: =Sum({$< SoldDate={"$(=Date(Max(SoldDate),'M/D/YYYY'))"}>} ITEMSOLD01)

Prev. Year Date: =Sum({$< SoldDate={"$(=Date(AddYears(max(SoldDate)+1,-1),'M/D/YYYY'))"}>} ITEMSOLD01)

Muthukumar Pandiyan
nagarjuna_kotha
Partner
Partner

Check attcached file and Make utr month selections accodingly it will give you day comparisons

-Nagarjun

nareshthavidishetty
Creator III
Creator III
Author

Hi,

Thanks for the post.

But need last year same day sales like i said

Today is Friday ,second week of march 3/10/2017 with this date sales i need to compare last year Friday ,second week of march 3/11/2016.


Thanks..

tresesco
MVP
MVP

Try :

Sum({<Month,SoldDate, SoldYear={"$(=Year(Today())-1)"},

  Month={"$(=Month(today()))"}, Week={"$(=Week(Today()))"},WeekDay={"$(=Weekday(Today()))"}>}ITEMSOLD01)