Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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 %

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 %

Not applicable

Re: How to compare 2 values ?

Thank you very much, it works.

Community Browser