topic Re: KPI in QlikView

KPI

master_student — Mon, 05 Dec 2016 13:28:47 GMT

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

Re: KPI

Gysbert_Wassenaar — Mon, 05 Dec 2016 13:30:08 GMT

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

Re: KPI

Mon, 05 Dec 2016 13:53:48 GMT

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))

Re: KPI

master_student — Mon, 05 Dec 2016 15:29:40 GMT

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

Re: KPI

Anonymous — Mon, 05 Dec 2016 16:25:56 GMT

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.

Re: KPI

master_student — Mon, 05 Dec 2016 20:16:47 GMT

how please

Re: KPI

Gysbert_Wassenaar — Tue, 06 Dec 2016 07:46:18 GMT

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 )

Re: KPI

master_student — Tue, 06 Dec 2016 09:37:24 GMT

Thanks

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

Re: KPI

Gysbert_Wassenaar — Tue, 06 Dec 2016 09:59:03 GMT

Use an expression as label for the expression column