Reload rows for macro - Qlik Community

Esneider · ‎2013-05-10

I need reload information file .txt.

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

marcus_sommer · ‎2013-05-13

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

first n ( load-befehl | select-befehl )

- Marcus

Esneider · ‎2013-05-13

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>

marcus_sommer · ‎2013-05-14

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