Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
miro_kopecky
New Contributor III

Table of similar words and counting them

Hi, I would be gratefull if you could hepl me with my task in Qlik Sense.
I have table words_frequency_1.Word which contains some similar words or symbols.
I need to write all similar words in another table only once.
Then I need to count how many times was every Word from table repeated in table.

I dont have big experience with script writing in Qlik Sense so I am asking for help.
Thanks in advanceSmiley Happy

1 Solution

Accepted Solutions

Re: Table of similar words and counting them

Is that Matched is a Field calculating from Script? If so, Try this
Count(TOTAL <Matched> Formula)
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
3 Replies

Re: Table of similar words and counting them

Can you provide sample
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
miro_kopecky
New Contributor III

Re: Table of similar words and counting them

Hi, I will specify my my request. 
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...

Bez názvu.png

Re: Table of similar words and counting them

Is that Matched is a Field calculating from Script? If so, Try this
Count(TOTAL <Matched> Formula)
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)