Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Esneider
Partner - Contributor III
Partner - Contributor III

Reload rows for macro

I need reload information file .txt.

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

Labels (1)
3 Replies
marcus_sommer
MVP
MVP

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

first n ( load-befehl | select-befehl )

- Marcus

Esneider
Partner - Contributor III
Partner - Contributor III
Author

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
MVP
MVP

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