Variables

[#1]

Hello

I am not sure if this is possible but i would like to update the variables values per month according to chnages i make in a spreadsheet. In this instance it will be the staff group, the figures chnage every month and i want the variable to reflect that when i run the staff in post report.

Is there a way to link the variable value to a vlaue in a spreadsheet?

[deepakk]

Hi ,

Instead of changing the data in spreadsheet, you can directly change the data in Qlikview.

I have attach a sample application in which you can modify the Budget information and the change in the will be seen the chart.

When you take your cursor to the Budget Field a play button appears, click on the button and you will be able to input data.

I hope this serve you purpose.

Deepak

[Oleg_Troyansky]

I'm not sure if this is a matter of terminology (e.g. do you truly mean the Variable as opposed the a Field in a Table...) but to answer your question - yes, you can define a Variable to be calculated based on values from fields and tables. In order to do it, you need to define your variable with the formula, using the statement SET (as opposed to LET). For example:

SET varTotalSales = '=sum(Sales)';

The variable will store the formula, and the $(varTotalSales) will return the actual value calculated every time you reference it.

[#4]

Cheers guys much appreciated apolgies for confusion in terminology i did mean the latter, thank Oleg got it cracked now cheers.