Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator III

DIFFERENCE UP/DOWN

Hi Community,


I have this type of table.

How do I create a column that contains the difference between the values ​​of the column 2015 and the column values ​​in 2016?


I wish to create a column called Difference containing the subtraction of the current year (2016) - the year before (2015 ) .


And add another column to represent everything with a kpi ( smiling face or angry )


Immagine.png

1 Solution

Accepted Solutions
migueldelval
Specialist
Specialist

Hi Fabio,

Please check this quick example and tell me.

Regards

Miguel del Valle

View solution in original post

5 Replies
migueldelval
Specialist
Specialist

Hi Fabio,

Could you attach a sample of your data or a qvw test.

Regards

Miguel del Valle

migueldelval
Specialist
Specialist

Hi Fabio,

Please check this quick example and tell me.

Regards

Miguel del Valle

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

Hi,

I use Qlik sense vers. 2.2.4

I'm not able to open your .qvw

migueldelval
Specialist
Specialist

Hi Fabio,

Sorry but I didn´t see that your question it was for QlikSense. I don´t Know how you can add a Smiley. But you can test this example.

Regards

Miguel del Valle

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

the example is exactly what I want to achieve.

Shorlty, you're suggesting we create two variables

1) year

2) the previous year

======================================

The year is selected by  the user from a filter box so that

could I define the current year based on what the person chooses?

Should I create a variable CURRENT_YEAR = "Year selected" and then previous_year CURRENT_YEAR = -1

What do you think about it?