# Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Valued Contributor II

## How to add new simple KPI measure for Expense Variance ?

Hi All

i accidently delete one of the KPI field . That is Expense Variance.

When i try to add in manually , it does not support simple KPI setting.

May i know how to add the column 5 , Row 2 field , so that it can display 26% from yeterday ?

Now it display blank.

Paul

7 Replies
Valued Contributor II

## Re: How to add new simple KPI measure for Expense Variance ?

my qvf

Honored Contributor III

## Re: How to add new simple KPI measure for Expense Variance ?

Not sure what exactly you need on this - Currently the table is showing error - Can you tell us your exact dimension and measures you need to rebuild it.

Valued Contributor II

## Re: How to add new simple KPI measure for Expense Variance ?

Hi Dig

1st Measure expression as below , will display expense amount of CY :-

SUM({<year = {"\$(=Max(year)-0)"},month={"<\$(=Max({<sales = {'*'}, year = {\$(=Max(year))}>}month))"},eXP={eXP}>}Amount*-1)/Rate

2nd Measure expression as below , will display expense % change LY vs CY :-

(

SUM({<year = {"\$(=Max(year)-0)"},month={"<\$(=Max({<sales = {'*'}, year = {\$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)

-

SUM({<year = {"\$(=Max(year)-1)"},month={"<\$(=Max({<sales = {'*'}, year = {\$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)

)

/

SUM({<year = {"\$(=Max(year)-1)"},month={"<\$(=Max({<sales = {'*'}, year = {\$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)

Paul

Not applicable

## Re: How to add new simple KPI measure for Expense Variance ?

Look like it's an extension object. You might need to download it from Qlik branch first

Esteemed Contributor III

## Re: How to add new simple KPI measure for Expense Variance ?

chk dis

Qlik Branch

Valued Contributor II

## Re: How to add new simple KPI measure for Expense Variance ?

Hi Chanty

Thank you for the link.

I already read thru , but unable to find any answer .

Paul

Valued Contributor II

## Re: How to add new simple KPI measure for Expense Variance ?

Hi Nhu

Thank you very much for your sharing

Yes i already download and install the extension , and i use the simple temple to create my KPI , and accidently i delete the last expression , and when i try to add , i am not able to add.

Paul