Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Calculating Growth Rate Using Variable

Hi,

I have defined two variables as follow;

vCYR = 1.19 & vLYR=1.84

I want to calculate the growth of the above and I used the following formula to generate the result;

($(vCYR) - $vLYR)) / $(vLYR)

The expected result in "-0.35", whereas I am getting "-0.00" as the answer.

The guidance and help on the above is highly appreciated.

1 Solution

Accepted Solutions
Highlighted
Contributor II
Contributor II

Re: Calculating Growth Rate Using Variable

Hi Baradwaj,

Thanks, for the formula.

Your formula gives -100.00% as the answer. I found the correct formula for the problem;

(($(vCYR)) - ($(vLYR))) / ($(vLYR))

The above formula works, and i do get the expected answers.

Cheers,

Kishore

View solution in original post

8 Replies
Highlighted
Contributor III
Contributor III

Re: Calculating Growth Rate Using Variable

You forget one brackets ($(vCYR) - $(vLYR)) / $(vLYR)

Highlighted
MVP
MVP

Re: Calculating Growth Rate Using Variable

Try correcting parenthesis, like:

=($(vCYR) - $(vLYR)) / $(vLYR)

Highlighted
Contributor II
Contributor II

Re: Calculating Growth Rate Using Variable

I have typed it correctly in the Qlike Sense, did a typing mistake here.

However, still I gt -0.00 as the answer.

Highlighted
Partner
Partner

Re: Calculating Growth Rate Using Variable

Hi ,

Try the following expression:

($(vCYR)/$(vLYR))-1 

Hope it helps

Regards

Highlighted
Partner
Partner

Re: Calculating Growth Rate Using Variable

Hi.

I do something similar and use: 

-1+($(vCYR)/$(vLYR))

John

 

Highlighted
Partner
Partner

Re: Calculating Growth Rate Using Variable

Hi,

Attached the app for reference.

Highlighted
Contributor II
Contributor II

Re: Calculating Growth Rate Using Variable

Hi Baradwaj,

Thanks, for the formula.

Your formula gives -100.00% as the answer. I found the correct formula for the problem;

(($(vCYR)) - ($(vLYR))) / ($(vLYR))

The above formula works, and i do get the expected answers.

Cheers,

Kishore

View solution in original post

Highlighted
Contributor II
Contributor II

Re: Calculating Growth Rate Using Variable

Hi Jhon,

Thanks for the formula, but the same as Baradwaj's formula it gives "100.00%" as the answer.

I have given the formula that works.

Cheers