topic Re: Read a text field and store it into a variable in QlikView

Read a text field and store it into a variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Is it possible to read a field which is text from a table and store the text value into a variable that can be used later?

Say the field is called “FiscalYear” and it contains this data “2016-2017”. How would I do this? Many of the examples I see

deal with numeric fields to be used with functions like SUM(), AGGR() and etc.

Thanks!

Re: Read a text field and store it into a variable

giakoum — Tue, 27 Sep 2016 14:03:50 GMT

use the fieldvalue function

Re: Read a text field and store it into a variable

sunny_talwar — Tue, 27 Sep 2016 14:04:49 GMT

Store while reloading or on the front end?

Re: Read a text field and store it into a variable

giakoum — Tue, 27 Sep 2016 14:05:05 GMT

or the peek function

Re: Read a text field and store it into a variable

Anonymous — Tue, 27 Sep 2016 14:06:09 GMT

I need to store the value while doing a LOAD ... from my SQL Server table.

Would you kindly include some code sample?

Re: Read a text field and store it into a variable

avinashelite — Tue, 27 Sep 2016 14:06:47 GMT

could please explain how you need to use this with an example ??

Re: Read a text field and store it into a variable

sunny_talwar — Tue, 27 Sep 2016 14:08:47 GMT

May be like this:

LOAD MaxString(FiscalYear) as Max

Resident Table;

LET vMaxFiscalYear = Peek('Max');

Re: Read a text field and store it into a variable

miguelbraga — Tue, 27 Sep 2016 14:10:10 GMT

Hey there,

It is possible to insert a text in a input box that will overwrite a variable and then use that variable in a TextBox and every object you want. Hope this makes it clear

Best regards,

D.A. MB

Re: Read a text field and store it into a variable

Anonymous — Tue, 27 Sep 2016 14:16:48 GMT

Sunny,

I followed your code. When I displayed the variable vMaxFiscalYear in a text object like:

= $(vMaxFiscalYear )

The text label shows a value of "2001". My actual data is "2017-16". What am I missing?

Re: Read a text field and store it into a variable

sunny_talwar — Tue, 27 Sep 2016 14:22:01 GMT

What happens when you use this: vMaxFiscalYear (Without dollar sign expansion?)

Re: Read a text field and store it into a variable

avinashelite — Tue, 27 Sep 2016 14:23:19 GMT

How many values you have in your FiscalYear field

and try without the $ sign once

Re: Read a text field and store it into a variable

Anonymous — Tue, 27 Sep 2016 14:25:49 GMT

Yes, without the dolloar sign worked. Since it's text data, I surrounded the expression with tick marks like

= '$(vMaxFiscalYear )'

and it also worked !!. Thanks for your help.

I will exploring Miguel's idea next.

Re: Read a text field and store it into a variable

Anonymous — Tue, 27 Sep 2016 14:26:59 GMT

I only have one row in my table.

Re: Read a text field and store it into a variable

sunny_talwar — Tue, 27 Sep 2016 14:28:03 GMT

Sounds good

Re: Read a text field and store it into a variable

antoniotiman — Tue, 27 Sep 2016 14:41:38 GMT

Hi,

Try

Load Max(FiscalYear) as FiscalYear;
Load SubField(FiscalYear,'-') as FiscalYear Inline [
FiscalYear
2017-16 ];
LET vMaxFiscalYear = Peek('FiscalYear');

Change Inline to Select .. From..

Regards,

Antonio

Re: Read a text field and store it into a variable

Anonymous — Tue, 27 Sep 2016 14:51:18 GMT

When you do a PEEK('Max"), how does it know which table "Max" belongs to or does it scan ALL the tables

to look for this column?? It appears the latter is what QV is doing since I have multiple tables.

Re: Read a text field and store it into a variable

sunny_talwar — Tue, 27 Sep 2016 14:53:51 GMT

It looks for a Max in all tables and that is why this name needs to be unique and should not match with any field name you already have in your application