Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use
if(QuarterName(Date1) = QuarterName(Date2) , Quantity , 0)