topic Sum(Count) in QlikView

Sum(Count)

Wed, 25 Nov 2020 16:16:04 GMT

I have a document that has two dimensions in the following order

Owner

View

The view is text and has 4 alternatives so I do not have difficulty with the count.

However I would like to work out the percentage of the views .

the simple formula would be Count(View)/Sum(Count(View)) for each owner.

Could someone please assist.

Regards

miguelbraga — Tue, 27 Sep 2016 16:09:45 GMT

Hey there,

Can you please post a sample data or a qvw so we can understand better your problem? It's unclear what you're trying to achieve.

Best regards,

D.A. MB

trdandamudi — Tue, 27 Sep 2016 16:11:21 GMT

May be as below:

Count(View) / Count(Total View)

sunny_talwar — Tue, 27 Sep 2016 17:13:35 GMT

Or may be this:

Count(View)/Count(TOTAL <Owner> View)