KPI

[master_student]

Hello Guys,

I would like to measure a KPI of that month comparing of the KPI of the last month.

example :

KPI : december 2016  VS KPI december 2015

to make my request more clear :

My date field has this format yyyymm example 201603 (is named period)

My calendar dimension is like that :

the link between my two tables calendar and the other is % period ID

this is how the period id is measured period_id&'' as [%PERIOD ID]

My final result would be like that :

KPI	2015october	2016october
Recharged	56889606,1	57464978,7

Any idea how to do it??

Thanks a lot

Ce message a été modifié par : master student

[Gysbert_Wassenaar]

Subtract one value from the other to see the difference between the two. If you need more help, provide more information. Perhaps you can find an answer to your question in one the discussions this search returns: https://community.qlik.com/search.jspa?q=same+month+last+year+comparison

[#3]

I suggest you to create a text area with the following code :

=Month(Today())&' '&Year(Today())&' : '&

sum(

     if(month(KPI_DATE)=month(Today()) and year(KPI_DATE)=year(Today()),

     KPI))

&' VS '&Month(Today())&' '&(Year(Today())-1)&' : '&

sum(

     if(month(KPI_DATE)=month(Today()) and year(KPI_DATE)=(year(Today())-1),

     KPI))

[master_student]

Thanks Gysbert. more details are mentionned in my first request.

[Anonymous]

Hi ,

You can set two variables for current month year and last month year and use the same in the two expressions.  Or if the calendar is created correct you can just create a pivot table and get the desired results.

[master_student]

how please

[Gysbert_Wassenaar]

My date field has this format yyyymm example 201603 (is named period)

If it's really a date field and there is only one value for each month like the first date of the month then you should be able to use expressions like:

Selected period: sum({<period={"=$(=Date(Max(period),'YYYYMM'))"}>} Amount )

Same period previous year: sum({<period={"=$(=Date(AddYears(Max(period),-1),'YYYYMM'))"}>} Amount )

[master_student]

Thanks

How to change the name of columus of my KPI's dynamically please,

[Gysbert_Wassenaar]

Use an expression as label for the expression column