topic Re: Monthdiffernce in QlikView

Monthdiffernce

Thu, 27 Nov 2014 13:31:25 GMT

Hi all,

I have created two varibale vDate1,vDate2

vDate1=min(IntimationDate)

vDate2=max(Date)

I need to Find Monthdifference Between vDate1 to vDate2 and need to create bucketing like

Count(ContractNumber) where MonthDifference<4Months

Count(ContractNumber) where MonthDifference>5Months

Count(ContractNumber) where MonthDifference=4-5Months

and use that in set analysis.??

like (Count({$<"Monthdifference>4">}ContractNumber))

Kindly help Also tell how to write it in Set analysis??

Thu, 27 Nov 2014 13:48:15 GMT

To calculate month difference:

Monthdifference = (((year(vDate2)*12)+month(vDate2)) - (((year(vDate1)*12)+month(vDate1))))

If you calculate that in LOAD script you can use it in Set Analysis afterwards the way you describe

MarcoWedel — Thu, 27 Nov 2014 13:49:44 GMT

LOAD Month(Date2)-Month(Date1)+(Year(Date2)-Year(Date1))*12 as Monthdifference

FROM YourSource;

Thu, 27 Nov 2014 14:00:17 GMT

Hi,

Can you help me regarding how to use vMonthdifference Varible in set analysis,like

Count({$<'$(vMonthDifference)'<4>}ContractNumber) is this right??

gandalfgray — Thu, 27 Nov 2014 14:34:34 GMT

I don't think you should use a variable for your Monthdifference field, to compare against a fixed value (ie 4) try like:

Count( {<Monthdifference={"<4"}> } ContractNumber)

If you want the users to be able to change the value to compare with you can have a variable (ie vMonthDiff) and use it like:

Count( {<Monthdifference={"<$(vMonthDiff)"}> } ContractNumber)

/gg