topic Re: Reload rows for macro in QlikView

Reload rows for macro

Esneider — Sat, 11 May 2013 02:21:56 GMT

I need reload information file .txt.

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

Re: Reload rows for macro

marcus_sommer — Mon, 13 May 2013 14:50:57 GMT

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

first n ( load-befehl | select-befehl )

- Marcus

Re: Reload rows for macro

Esneider — Mon, 13 May 2013 18:03:37 GMT

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

marcus_sommer — Tue, 14 May 2013 07:33:21 GMT

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