topic Re: Calculate month in QlikView

Calculate month

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

Hi Experts,

I have 3 fields those are Month, year, period

now i am having the data like this

month year period

03 2018 07/2017

03 2018 09/2017

Now i want to calculate the difference between month year and period how to calculate the difference ?

Thanks in advance

Re: Calculate month

Anil_Babu_Samineni — Mon, 09 Apr 2018 13:44:32 GMT

There is no Measure in your Table? Will you able to share sample

Re: Calculate month

Anonymous — Mon, 09 Apr 2018 13:52:44 GMT

NO measure in the table i want to calculate the difference months b/w the period and month year,

Re: Calculate month

sasiparupudi1 — Mon, 09 Apr 2018 13:59:57 GMT

Try

MakeDate(Year,MOnth,1)-date#(period,'MM/YYYY'),

Re: Calculate month

Anil_Babu_Samineni — Mon, 09 Apr 2018 14:01:36 GMT

Perhaps this?

Date(MonthName(month&year), 'MM/YYYY') - Date(period,'MM/YYYY')

Re: Calculate month

MarcoWedel — Mon, 09 Apr 2018 20:30:43 GMT

what is the difference you would expect given your sample data?

Re: Calculate month

boorgura — Mon, 09 Apr 2018 20:57:42 GMT

This should give you the difference number of months:

((year-1) - right(period, 4))*12 + (month + 12 ) - Left(period, 2)

Re: Calculate month

vishalarote — Tue, 10 Apr 2018 06:08:50 GMT

Try this it works

load *,

Date(Date#(MonthYear,'MM/YYYY'),'MM/YYYY')-Date(Date#(period,'MM/YYYY'),'MM/YYYY') as Difference;

load *,

month&'/'&year as MonthYear Inline [

month,year,period

03,2018,07/2017

03,2018,09/2017

];

Re: Calculate month

Anonymous — Tue, 10 Apr 2018 06:13:45 GMT

Hey Vishal,

Nice Explanation.

Re: Calculate month

gireesh1216 — Tue, 10 Apr 2018 07:10:48 GMT

This one correct.