Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

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)