Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
Look like it's an extension object. You might need to download it from Qlik branch first
chk dis
Hi Chanty
Thank you for the link.
I already read thru , but unable to find any answer .
Paul
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