Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
williamesneider
New Contributor II

Reload rows for macro

I need reload information file .txt.

For example the 1000 rows,  only load first 100 rows using macro.

3 Replies

Re: Reload rows for macro

You could by using macros set the variable "n" for load with first:

first n ( load-befehl | select-befehl )

- Marcus

williamesneider
New Contributor II

Re: Reload rows for macro

Hi Marcus Sommer,

Some example you can share?

Thanks,

William Esneider Peña

E-mail: william.pena@gpstrategy.com.co <xwilliam.pena@gpstrategy.com.co>

Skype: william_esneider

Móvil: 57 314 3950954

Calle 67 No 7-57 Of 302

Tel: 571 2171641

Bogotá - Colombia

2013/5/13 Marcus Sommer <qcwebmaster@qlik.com>

**

QlikCommunity <http://community.qlik.com/index.jspa> Re:

Reload rows for macro created by Marcus Sommer<http://community.qlik.com/people/marcus_sommer>in

Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/345186#345186>

Re: Reload rows for macro

Hi William,

I haven't any example for this, it is only an idea:

sub xyz

.........

.........

ActiveDocument.Variables("N_for_First").SetContent 100, true

ActiveDocument.Reload

..........

end sub

I don't know what happens if "N" > RowsCount or "N" = "*wildcard*" - perhaps it must solve in a loop-command to separate a normally Load and a macro-reload.

- Marcus

Community Browser