topic Re: comparing month year between two dates in QlikView

comparing month year between two dates

srikantj — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: comparing month year between two dates

tripatirao — Fri, 10 Mar 2017 10:05:11 GMT

Hi,

Can you please elaborate with example what u want.

Regards

Re: comparing month year between two dates

srikantj — Fri, 10 Mar 2017 10:10:59 GMT

There are two date fields

i just want to compare month year of one date to month year of another date

if(4/2016=5/2017, 1,0)

Re: comparing month year between two dates

tresB — Fri, 10 Mar 2017 10:15:44 GMT

May be like this?

InMonth(Date1, Date2, 0)

InQuarter(Date1, Date2,0)

Re: comparing month year between two dates

dsharmaqv — Fri, 10 Mar 2017 10:16:20 GMT

Extract month and year for both fields

Month(date1)

Year(date1)

Month(date2)

Year(date2)

Now you can compare these derieved fields

incase you need month year then concatenate both fields

Date#(Month(date1)&', '&Year(date1) ,'MMM, YYYY') as Month_Year1

Date#(Month(date2)&', '&Year(date2),'MMM, YYYY') as Month_Year2

Re: comparing month year between two dates

srikantj — Fri, 10 Mar 2017 10:45:48 GMT

But i want to give expression if equals quantity not true or false

Re: comparing month year between two dates

srikantj — Fri, 10 Mar 2017 10:46:28 GMT

i know this way but i want simple way

as i need to write other expressions based on that

Re: comparing month year between two dates

tresB — Fri, 10 Mar 2017 10:48:47 GMT

InMonth()/InQuarter() themselves return true or false. You can try like: =If( InMonth(Date1,Date2,0), 'true', 'false')

Re: comparing month year between two dates

dsharmaqv — Fri, 10 Mar 2017 10:50:33 GMT

what do you want to do exactly ?

Re: comparing month year between two dates

srikantj — Fri, 10 Mar 2017 10:56:54 GMT

if(quarter year date1=quarter year date 2,quantity,0)

is there any pre defined function??????

Re: comparing month year between two dates

vinieme12 — Fri, 10 Mar 2017 11:13:16 GMT

use

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