How to compare 2 values ?

[#1]

Hello,

I'm new on Qlikview, and I'd like to compare 2 years, month by month.(Janv.2011 vs Janv 2012)

Can you explain me how can I do this ? I tried to do this but it didnt' work.

For years, I used the fonction year(date_facturation) and for months I used the fonction month(date_facturation).

Thank you very much,

[MayilVahanan]

Hi

PFA

Are you looking like this

[#3]

Hi,

Thank you for your answer,

I'm sorry, but it doesn't work, i'd like to divide 2011 with 2012, month by month.

Have you got any idea ?

Thank you very much.

[Clever_Anjos · Accepted solution]

Add another expression:

sum(Vlr)/Above(sum(Vlr)) and format it as a %

[#5]

Thank you very much, it works.