topic Re: How to assign multiple values to a single variable in script? in QlikView

How to assign multiple values to a single variable in script?

Sat, 24 Oct 2015 17:24:24 GMT

Hi All,

I am a newbie to QV, I am trying to assign multiple values to a single variable using LET as below,

Load * inline[

Num

];

Let val=Num;

Is it possible to display all the values of "Num" when variable "val" is loaded, because when loaded I am getting Null for "val" instead of 1,2,3,4.

Re: How to assign multiple values to a single variable in script?

MK_QSL — Sat, 24 Oct 2015 17:43:00 GMT

Data:

Load * inline

[

Num

];

TempConcat:

LOAD Concat(Distinct Num,', ') as TempNum Resident Data;

Let val = FieldValue('TempNum',1);

Drop Table TempConcat;

Re: How to assign multiple values to a single variable in script?

Sat, 24 Oct 2015 17:56:06 GMT

Hi Manish,

Thanks for the reply.I want the values to be displayed one by one as loaded in inline table by using a variable as below,

In the listbox by using variable name

=$(val)

Sorry for the confusion.

Re: How to assign multiple values to a single variable in script?

MK_QSL — Sat, 24 Oct 2015 21:05:39 GMT

Why you want to use variable in List Box..

You can simply use Field Num in list box... What is the point of creating variable!

Re: How to assign multiple values to a single variable in script?

Sun, 25 Oct 2015 10:41:00 GMT

My requirement consists of an expression to be evaluated and used in a "for" loop. I tried using the expression directly in for loop but it wouldn't work, so I am trying to evaluate the expression using "LET" and then using that variable in for, but even that is not working. So I am trying to evaluate the expression using "LET" first. The expression is

for i=num(Addmonths(MaxDate,-12,1)) to num(MaxDate)

Test1:

Load *,

sum(Current12M) as Total,

Key

Resident Final

where Exists(Key);

Next i;

Re: How to assign multiple values to a single variable in script?

MK_QSL — Sun, 25 Oct 2015 15:27:47 GMT

can you provide sample data and result you want to achieve using loop?

Re: How to assign multiple values to a single variable in script?

Oleg_Troyansky — Sun, 25 Oct 2015 22:02:37 GMT

Hi Priyanka,

QlikView variables, in contrast to fields, can only hold a single value. In your initial example, you create a field Num with several values, which is fine, and then you are trying to assign all the values of Num to a variable val, which is incorrect.

If you want a single field value to be assigned to a variable, you can use one of the functions that can fetch the field value either from a table or from the value list. Check out the following functions:

Peek() lets you peek the field value from a table

FieldValue() lets you fetch a single value from a list of field values (disregarding of a table)

Conversely, when you need to use variables in data load statements, you can't use them directly. Instead, you need to use them within a $-sign expansion. For example:

LOAD

$(num_variable) as Field1,

'$(string_variable)' as Field2,

...

Check out my new book QlikView Your Business. In the book, I describe in detail how to use variables for a variety of analytical needs in the script and in the UI.

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense