Qlik Community

Qlik Sense App Development

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

paulyeo11
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
paulyeo11
Valued Contributor II

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

my qvf

Digvijay_Singh
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.

Capture.JPG

paulyeo11
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

sureshqv
Esteemed Contributor III

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

chk dis

Qlik Branch

paulyeo11
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

paulyeo11
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