Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
Essonne
New Contributor

Sum and max through all columns

Hello everyone,

I'm supposed to analyse a document-term matrix using Qlik Sense. My rows represent documents and my columns represent words. The values of the table are the occurrences of each word in each document.

What I need is knowing the words appearing most in my corpus. For that, I have to compute the sum of each word through all documents (rows) and choose the max, or (better) have a ranking from the most to the least appearing.

I tried to do it on my own, but my capabilities in Qlik Sense are very limited, especially for the script part. Can someone help me find a solution?

Thanks a lot in advance.

 

4 Replies

Re: Sum and max through all columns

Perhaps this?

Firstsortedvalue(aggr(sum(measure), document), -document)
Life is so rich, and we need to respect to the life !!!
Essonne
New Contributor

Re: Sum and max through all columns

Thanks for your answer @loveisfail. I don't understand what does measure and document stand for, since I have many documents as rows and several words as columns. I don't have only one measure but more than 2000.

Re: Sum and max through all columns

Can you come back with some example and expected result to understand little more..
Life is so rich, and we need to respect to the life !!!
Essonne
New Contributor

Re: Sum and max through all columns

Let's imagine we have two documents : "you are learning" and "they are understanding". The resulting matrix would be :

 

                                     you | are | learning | they | understanding

document_1             1    |   1    |        1        |    0    |             0

document_2             0    |   1    |        0        |    1    |             0

 

My objective is to order the words (that are in columns) from the most appearing in the corpus to the least appearing. In this  exemple, the word "are" should be the first with a number of occurrences = 2.

 

What I did is that I called the crosstable function and made an aggregation. I don't know if there is a simpler way.

Community Browser