topic Re: Text Box formula in QlikView

Text Box formula

danialier — Thu, 20 Mar 2014 16:59:22 GMT

Hello,

I have three text boxes: A, B and C.

> In Text Box A I have a formula that shows the revenues in Quarter 1

> In Text Box B I have a formula that shows the revenues in Quarter 2

> In Text Box C I want to calculate the quarter over quarter growth, so this is Q2/Q1-1

Formulas behind text box A and B are quite complex, so if I need to estimate the quarter over quarter growth with these formulas in text box C it will be quite challenging...

Question: is there a way to put in Text Box C a simple formula saying: Object ID (from Text Box B) / Object ID (from Text Box A) -1

Actually the Object ID from Text Box A is AAA and the Object ID from Text Box B is BBB, so formula would be like BBB/AAA-1

Please help !

dani

Re: Text Box formula

Nicole-Smith — Thu, 20 Mar 2014 17:03:27 GMT

Dani Alier wrote:

Question: is there a way to put in Text Box C a simple formula saying: Object ID (from Text Box B) / Object ID (from Text Box A) -1

No. But you can store each calculation in a variable, and call the variables in the text boxes instead.

Re: Text Box formula

preminqlik — Thu, 20 Mar 2014 17:09:54 GMT

try with variables

Re: Text Box formula

its_anandrjs — Thu, 20 Mar 2014 17:10:32 GMT

Hi,

By variable you are able to do this like

(vQ2revenue / vQ1revenue) -1

and do calculation in variables that are in your Text Box A = vQ1revenue like

Text Box C = vQ2revenue

Hope this helps

Thanks & Regards

Re: Text Box formula

MK_QSL — Thu, 20 Mar 2014 17:10:39 GMT

As Nicole Said, You can create a variable for your Q1 and Q2 expresion and use them in third text box

$(vQ2)/$(vQ1)-1