Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
fmazzarelli
Contributor 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
Valued Contributor

Re: DIFFERENCE UP/DOWN

Hi Fabio,

Please check this quick example and tell me.

Regards

Miguel del Valle

5 Replies
migueldelval
Valued Contributor

Re: DIFFERENCE UP/DOWN

Hi Fabio,

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

Regards

Miguel del Valle

migueldelval
Valued Contributor

Re: DIFFERENCE UP/DOWN

Hi Fabio,

Please check this quick example and tell me.

Regards

Miguel del Valle

fmazzarelli
Contributor III

Re: DIFFERENCE UP/DOWN

Hi,

I use Qlik sense vers. 2.2.4

I'm not able to open your .qvw

migueldelval
Valued Contributor

Re: DIFFERENCE UP/DOWN

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
Contributor III

Re: DIFFERENCE UP/DOWN

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?

Community Browser