topic [ASK] how to filter data that load to QVW from edit script in QlikView

[ASK] how to filter data that load to QVW from edit script

Tue, 02 Nov 2010 06:50:57 GMT

hello...

i wanna ask a question

how to load data but only certain date?

example, i only want to load data that in year 2010

can i use SET function?

b'coz if i use where statement, it will take a while to wriite since tables is pretty much

thx...

[ASK] how to filter data that load to QVW from edit script

sparur — Tue, 02 Nov 2010 07:19:22 GMT

Hello

you can use variable in load script:

SET vYear = '2010';

LOAD ... FROM,,,

WHERE [Year] = '$(vYear)';

[ASK] how to filter data that load to QVW from edit script

Tue, 02 Nov 2010 07:29:20 GMT

hello sparur

thx for ur reply

i've tried that way

and unfortunately, the table with date isn't only 1

so what do i want that can i use 1 syntax/function to represent year in every table that contain date?

can i do that?

thx..

[ASK] how to filter data that load to QVW from edit script

sparur — Tue, 02 Nov 2010 07:41:25 GMT

yes. you can use vYear variable in any LOAD statement. Or you can create new variable (with date for example) for restriction data. or you can modify vYear variable into different year and use it with new value.