topic Re: How to add new simple KPI measure for Expense Variance ? in App Development

How to add new simple KPI measure for Expense Variance ?

paulyeo11 — Sun, 03 Jul 2016 02:12:27 GMT

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

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

paulyeo11 — Sun, 03 Jul 2016 02:13:14 GMT

my qvf

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

Digvijay_Singh — Sun, 03 Jul 2016 12:14:31 GMT

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 ?

paulyeo11 — Sun, 03 Jul 2016 16:07:14 GMT

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 ?

Mon, 04 Jul 2016 06:47:37 GMT

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 ?

Chanty4u — Mon, 04 Jul 2016 06:59:00 GMT

chk dis

Qlik Branch

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

paulyeo11 — Mon, 04 Jul 2016 07:40:21 GMT

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 ?

paulyeo11 — Mon, 04 Jul 2016 07:42:12 GMT

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