Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

load variable in qlikview

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.

3 Replies
Roop
Specialist
Specialist

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
Partner - Specialist III
Partner - Specialist III

Probably the Include() technique or this one:

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