topic Re: Load a column whose name was defined via a variable in the Loadscript in QlikView

Load a column whose name was defined via a variable in the Loadscript

MartinGer — Sat, 16 Nov 2024 00:27:22 GMT

Dear community,

currently i'm working on an applikation where i should show some numbers from the last week. Therefor i get a table with the values per week from our finance team. in this tabel every week is a own columen.

The file contains a lot of data, but I only need one column, always the previous week.

So the idea was to define this colume as a varible and use this variable in the Load script. But whit my script it doesn’t work.

.-------

sub Ex

set PreviousWeek = '2020/24';

// -- Previous Week --

C_W: // Costumers per Week
LOAD
'$(PreviousWeek)' as ValuesPreviousWeek
FROM [\\s-at00-120\DataWarehouseLN\Common\107_Load\Verkaufszahlen\Käufer_Woche.qvd] (qvd);

end sub

.----

sincerly Martin

Re: Load a column whose name was defined via a variable in the Loadscript

vanessa_loschi — Fri, 19 Jun 2020 17:26:35 GMT

Hello,

Try it without single quotes.

LOAD
$(PreviousWeek) as ValuesPreviousWeek
FROM [\\s-at00-120\DataWarehouseLN\Common\107_Load\Verkaufszahlen\Käufer_Woche.qvd] (qvd);

Regards.

Re: Load a column whose name was defined via a variable in the Loadscript

MartinGer — Mon, 22 Jun 2020 04:23:23 GMT

Thanks Vanessa,

you would astonish how mutch Trials i had done on this Topic without success.

The more grateful I am for your tip.

sincerly Martin