topic Comparison actual Year in QlikView

Comparison actual Year

pgalvezt — Tue, 24 Jan 2017 14:42:26 GMT

Hello,

Im trying to compare Actual year vs Last Year by (Day-Month) , means Date(Date,'MM-DD), in pivot chart. Obviously, with month dimension there´s no problem with that because the two are showing up in the same cell, but I would like to show (Day-Month) in the same cell) , Actually my output is different cell, Because are two different years.

My Expression Are :

Current Year:

If(FieldA = '1', Num(Sum(FieldB)/Divisor,'#.##0'),

If(FieldA = '2', Num((Sum(FieldC))/Divisor,'#.##0')))

Last Year:

Sum({<Año={$(xAñoAnt)},Fecha,FechaAA,FechaDiaMes>}if(FieldA = '1', Num(FieldB,'#.##0'),

Num(FieldC,'#.##0')))

Thanks!

Re: Comparison actual Year

pgalvezt — Tue, 24 Jan 2017 16:04:51 GMT

Any Help?

Thank you!

Re: Comparison actual Year

vamsee — Tue, 24 Jan 2017 16:16:12 GMT

Can you share a sample output you desire and one which you are getting?

Re: Comparison actual Year

pgalvezt — Tue, 24 Jan 2017 16:22:06 GMT

Hello,

Im getting this : (Photo).

The output What I looking for is both years in the same column.

Real AA

01-01 741.609 298.487

Thanks!

Re: Comparison actual Year

pgalvezt — Tue, 24 Jan 2017 18:35:16 GMT

Found my own solution doing mapping to last year and renamed the field as Actual year. Now I can see Day-Month correctly in my dimenssion.