Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to compare 2 values ?

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,

1 Solution

Accepted Solutions
Employee
Employee

Re: How to compare 2 values ?

Add another expression:

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

View solution in original post

4 Replies

Re: How to compare 2 values ?

Hi

PFA

Are you looking like this

Not applicable

Re: How to compare 2 values ?

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.

Employee
Employee

Re: How to compare 2 values ?

Add another expression:

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

View solution in original post

Not applicable

Re: How to compare 2 values ?

Thank you very much, it works.