7 Replies Latest reply: Jul 4, 2016 3:42 AM by Yeo Poh sai

# 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

my qvf

• ###### 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.

• ###### 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

• ###### 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

• ###### 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

• ###### 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