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: 
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.