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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How many totals rows do I have in my QV model?

Hi Dear All,

I want to know in total how many rows I have in my one of Qlikview model. Do you know where to look at? I will use this information to see how much size approximately my model takes place in order to decide server size.

Many thanks in advance

Cheers

Kezy

8 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Open the Tables tab of the Document Properties window.

Or use the Document Analyzer application: Document Analyzer V2 -- a major update


talk is cheap, supply exceeds demand
Not applicable
Author

Hi Gysbert,

Thanks for help. But I want this to export to somewhere excel. There is a button but I couldnt run it. its extention wasnt open. Do you how to do it_?

many thanks

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Create a Table box object. Enable the option Show System Fields and add the fields $Table and $Rows to the table box. Export the Table box to excel.

Or use the Document Analyzer.

This blog post may be of interest as well: Recipe for a Memory Statistics analysis


talk is cheap, supply exceeds demand
Not applicable
Author

Gysbert

Thankful for the help. But I am newbie in qlikview like 2 months. SO could you tell me how to see it clearly? If you dont mind

Regards

Kezy

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See what clearly?


talk is cheap, supply exceeds demand
Not applicable
Author

I dont know how to do it. Ok documents but cant take it to somewhwere like excel???

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Do what?


talk is cheap, supply exceeds demand
Not applicable
Author

How can I export these information total rows number, total fields..... to excel or to somewhere? I am new in qlikview.

If you exactly how to do it I can understand...

thanks