loading table of formulas from Excel into Qlikview

[#1]

Hi all,

I would like your assistance.

I am trying to create a KPI Dashboard and in order to avoid additional work, I would like to create a table in Excel that contains the Qlikview formulas in the cells.

Then when I read in the Excel sheet into Qlikview, I simply want to use the following equation

=$(=CurrentMonthActual)

or  =$(=PreviousMonthActual)

and it will calculate the value for each of these.

I have attached the Excel spreadsheet that I have created, but it doesn't there yet...

Could you please help?

The variable vPeriod and vPriorPeriod is created in Qlikview itself but basically just takes the max period and max period -1

[#2]

Thank you so much for helping me

[#3]

Hi Clever,

Once again I just wanted to thank you for your assistance on this.

I was just wondering if you were able to simplify the equation a bit so that it could work?

I have tried to change it based on your feedback, but haven't managed to get it to work yet.

I look forward to hearing from you,

Lucille

[Clever_Anjos]

Sorry, Lucille, hard times here these days, going to try to do this tonight,

If the expressions were simpler (without nested Set Analysis, it would work for sure)

[Clever_Anjos · Accepted solution]

LucyBotha‌, sorry about taking so much time.

Please check attached if it solves your needs

[#6]

Hi,

That worked thank you!

I also changed my vPriorPeriod = vPeriod -1

It wasn't a period anymore but a number..

Thank you so much for helping me in between everything. I know you are busy as well

[Clever_Anjos]

You´re welcome

[Clever_Anjos]

I could notice that your data seems to be in Portuguese. Do you speak Portuguese?

[#9]

No unfortunately not, I just used the template exactly to understand why my version was breaking