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

comparing month year between two dates

hi

I have two dates

date1          date2

4/24/2016    5/14/2017

3/30/2017    6/17/2015

.

.

i want to compare  month year of date1 =  month year of date 2

and quarter year of date 1 = quarter year of date 2

Qliksss suggest

10 Replies
vinieme12
Champion III
Champion III

use

if(QuarterName(Date1) = QuarterName(Date2) , Quantity , 0)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.