Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
PASHA
Contributor
Contributor

Month on Date

Dear Team,

   Greetings,

In my dash board i am comparing last year ( sale month ) sales and present year sale month sales, for present year i am getting as on date but in last year it is taking whole month for this formula (Sum({$<SALEYEAR={2018}>}NETAMT))

can any one help me how to check sales of both year same days.

 

Thanks.

 

 

1 Reply
Channa
Specialist III
Specialist III

vTodate=date(num(Month(max(Date)))&'/'&day(today())&'/'&year(max(Date))-1)

 

if you have month selection use this it will bring today of  selected month

 

take date between monthstart and vTodate

 

share your qvf i can check

Channa