topic Load with variable values in QlikView

Load with variable values

agni_gold — Mon, 05 Jun 2017 20:17:02 GMT

Hi friends,

I have column values in one variable like ,

variable name : vField

'A','B','C'

i want to load like

Load $(vField) from XYZ.qvd (qvd);

but it is not loading , can you guys help

Re: Load with variable values

agni_gold — Mon, 05 Jun 2017 20:23:58 GMT

also tried like

"A","B","C"

but not

Re: Load with variable values

krishnacbe — Mon, 05 Jun 2017 20:35:03 GMT

Hi,

Please find the attached sample.

Re: Load with variable values

agni_gold — Mon, 05 Jun 2017 21:05:21 GMT

DimensionMax:

Load count(Header) AS Count ,

Header AS Field

// Concat(Chr(91) & Header & Chr(93), ',',Load_Order) AS Fields

Resident Column_Header_temp

Group by Header

order by Load_Order;

Drop Table Column_Header_temp;

Let vNoofField= NoOfRows('DimensionMax');

Let vFields2=Peek('Field',0,'DimensionMax');

For i=0 to NoOfRows('DimensionMax')-1

Let vFields1 = Peek('Field',0,'DimensionMax');

Let vFields = Concat(Chr(91) & Peek('Field',$(i),'DimensionMax')& Chr(93), ',');

bold line is not working for me can you please tell what wrong i am doing ?

Re: Load with variable values

marcus_sommer — Tue, 06 Jun 2017 11:45:05 GMT

I think this will be useful for you: Re: Interesting challenge: How to create a real table from a list of field names?

- Marcus

Re: Load with variable values

tamilarasu — Tue, 06 Jun 2017 12:19:21 GMT

Hi Agnivesh,

Try this,

DimensionMax:

Load count(Header) AS Count ,

Header AS Field

Resident Column_Header_temp

Group by Header

order by Load_Order;

Drop Table Column_Header_temp;

Temptable:

Load Concat(Chr(39) & Field & Chr(39),', ') as Field_Names

Resident DimensionMax;

Let vFields = Peek('Field_Names',0,'Temptable');

DROP Table Temptable;

Re: Load with variable values

krishnacbe — Tue, 06 Jun 2017 13:22:07 GMT

You should use SET instead of LET.

Set vFields = Concat(Chr(91) & Peek('Field',$(i),'DimensionMax')& Chr(93), ',');