topic Re: load variable in qlikview in QlikView

load variable in qlikview

Thu, 19 Mar 2015 15:58:59 GMT

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.

Re: load variable in qlikview

Roop — Thu, 19 Mar 2015 16:09:16 GMT

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

Re: load variable in qlikview

sunny_talwar — Thu, 19 Mar 2015 16:23:57 GMT

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,

Re: load variable in qlikview

jpenuliar — Thu, 19 Mar 2015 16:26:09 GMT

Probably the Include() technique or this one:

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