topic Formula in Text object in QlikView

Formula in Text object

Mon, 31 May 2010 07:56:24 GMT

Hi,

I'm creating a text object to calculate variances for different dimension.

I can do a general formula just to calculate ALL, but, how do i make a dynamic formula, so that, for example, when year or month or some other dimension is selected, the formula is able to compute the right figure?

Thanks.

Formula in Text object

Mon, 31 May 2010 08:05:27 GMT

Hi nick,

For this you will have to create variables in your application. When selections are made, then changes should be reflected in a variable and these changed variables can be crosschecked using some conditions in your text object and then do the necessary operations you want to perform. here you must use the $(variable) to get the values stored in the variable. Hope this helps you.

Thanks Joseph......

Formula in Text object

Mon, 31 May 2010 09:53:24 GMT

Hi Joseph,

Thanks for your suggestion.

I managed to use set analysis like Sum ({$<Year={$(=Max(Year))}>}[Amount])

But this formula only allows me to take the max year for sum.

How can i create a formula to take in all the selected values of different dimensions? For example, i want to include all the selected market, year, month? to make it dynamic.

Thanks.

Formula in Text object

Tue, 01 Jun 2010 06:16:26 GMT

Hi Nick,

Herewith i have attached an example for your reference. Pls check the "Variable overview" & find the expression in the text box. I hope this will help you.

Regards

Rajesh