Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add total of rows to text object?

Hi!

I'm loading content from several excel documents and showing them in a table box. I'm hiding rows that contains the text "Done" in a certain column. Over time the rows get's fewer and fewer as more and more obejcts are marked with "Done" in the source system. Both the excel and qv document is updated regularly. To easily present that, I'd like to count all rows in a specific column and present a total  as a single value, in a nice text object or something. Can it be done?

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Yes it can be done.

Simply put =count(field) as expression in text object.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Yes it can be done.

Simply put =count(field) as expression in text object.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

Thanks. Who knew it was so simple! 😄

eduardo_dimperio
Specialist II
Specialist II

If this answer are correct, please mark as it, to keep only open questions