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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
dattasud
Contributor III
Contributor III

How to get total row count from input tmap row

Hello All,

 

I am calculating percentage of total for a specific column. With a tAggregateRow, I grouped based on a column (Account_Status). Now I need to calculate the percentage of each status out of total. So, I am using tMap after my tAggregateRow. I created a new column (Account%) in my output. 

I need to execute:

(total of Account_Status/total input row count)*100

 

How can i get total row count of my input row of the tmap? Please help 

Labels (3)
1 Solution

Accepted Solutions
dattasud
Contributor III
Contributor III
Author

I got the row count using global map variable :
(Integer) globalMap.get("tSalesforceInput_2_NB_LINE"))

Thanks.

View solution in original post

1 Reply
dattasud
Contributor III
Contributor III
Author

I got the row count using global map variable :
(Integer) globalMap.get("tSalesforceInput_2_NB_LINE"))

Thanks.