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: 
miro_kopecky
Contributor III
Contributor III

Duplicated words in table

Hi, I have table, which contains 3 columns. (as you can see in the Picture)
First column means from which file Word in the third column comes from.
Second column means how many times is Word located in that file from where it comes from.
I need to create 4th column where will be counted how many times is one Word located in whole 3rd column.
For Word 'Zuzana' it should be 2 because there are 2 words zuzana in 3rd column.
For Word 'Zruč-Senec' it should be 1 because there is only 1 Word zruč-senes in 3rd column.
For Word 'Znojmo' it should be again 2 and so on...

I dont have many experience with script writing in Qlik so I am asking for help.
Thank in advance.
 
Bez názvu.png
Labels (1)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Something like sum(TOTAL <Matched> WordCountRight). If that doesn't work then we'll need more information about the names of the fields used and the expression you use to calculate the values in the second column.

talk is cheap, supply exceeds demand