topic Re: How to create array in Qlikview and store values in it using inputbox in QlikView

How to create array in Qlikview and store values in it using inputbox

vikasmahajan — Tue, 01 Sep 2015 11:37:46 GMT

Dear all,

How to create arrays in qlikview using input box and store values in variable.

Vikas

Re: How to create array in Qlikview and store values in it using inputbox

marcus_sommer — Tue, 01 Sep 2015 12:14:44 GMT

You could use concat() to create a value-list like an array:

vArray:

= concat(distinct Field, ';')

and you could with substringcount() and subfield() read/access the content.

- Marcus

Re: How to create array in Qlikview and store values in it using inputbox

petter — Tue, 01 Sep 2015 12:47:03 GMT

You can also create some pseudo-arrays like this:

The v3 shows the formula to access the value of vArr[2] dynamically by and index which is v2 in this case. This is not a very efficient storage structure and should be use with a limited number of values. Marcus advice will give a much more compact storage whereas my suggestion give something more similar to real arrays in other programming/scripting languages...

Re: How to create array in Qlikview and store values in it using inputbox

vikasmahajan — Wed, 02 Sep 2015 04:00:29 GMT

Suppose vArr[1] = 123 (123) value i want to hold in other variable how we can do the same.

Thanks

Vikas

Re: How to create array in Qlikview and store values in it using inputbox

marcus_sommer — Wed, 02 Sep 2015 04:19:11 GMT

What do you want to do with this array - what is the aim? Maybe there are other ways.

- Marcus

Re: How to create array in Qlikview and store values in it using inputbox

petter — Wed, 02 Sep 2015 04:32:06 GMT

You could do it like this:

vOtherVar = '$(vArr[1])';

Re: How to create array in Qlikview and store values in it using inputbox

vikasmahajan — Wed, 02 Sep 2015 04:48:03 GMT

please check i am not able to get values in vOtherVar ???

Re: How to create array in Qlikview and store values in it using inputbox

petter — Wed, 02 Sep 2015 04:50:57 GMT

As in many things in QlikView it depends on the context.

So if you want to assign the vArr[1] variable to v1 with the help of an Action you would write

=vArr[1]

directly in the Value entry box in the dialog box - no need for enclosing it in quotation marks.

Re: How to create array in Qlikview and store values in it using inputbox

petter — Wed, 02 Sep 2015 04:53:27 GMT

As always QlikView is case-sensitive when it comes to Field-names and Variable-names.

The expression in the second text box could be simply:

=vARR[1]

without any quotation marks or $-sign expansion. See the attached fixed QVW....

Re: How to create array in Qlikview and store values in it using inputbox

petter — Wed, 02 Sep 2015 04:58:58 GMT

I discovered something more in your QVW so I updated the application and have attached with the modification.