load variable in qlikview

[#1]

Hello,

I have make a Excel sheet with default variables and load in Qlikview. Then I have make variables if default values in the variable overview.

My question is: how can I load the default variables in the dashboard?

My second question is: How can a customer/user add data in the dashboard, for example the default value is 8 and the user add 9? How can I add?

Can someone help me?

Thanks in advance.

[Roop]

Use an Input Box to allow data entry for the user.

Default variables can be added into the script with the LET or SET commands.

e.g.

Set vHolidays = '2015/12/24', '2015/12/25', '2015/12/26';  // Holidays

[sunny_talwar]

You already have the Excel (with variables) loaded into your application? or are you looking for a method to load them through Excel file? If later is true than you can use the following code to load your variables from Excel into your application:

TempVariable:

LOAD Variables,

     Value

FROM

[Source-Data\MROSKU\Variables.xlsx]

(ooxml, embedded labels, table is Variables);

For i = 0 to NoOfRows('TempVariable')-1

          LET vName = Peek('Variables', i, 'TempVariable');

          LET $(vName) = Peek('Value', i, 'TempVariable');

Next i

LET i = Null();

LET vName = Null();

Drop Table TempVariable;

For addressing your second question, I think what rupe proposed will be a good option for you where you create an input box object for variables whose values can change. User can just input new values (and replace the existing one)

Best,

S

[jpenuliar]

Probably the Include() technique or this one:

http://community.qlik.com/thread/45562