Help! How to calculate percentage of Sum of Count of a field?

[dushyant]

Hello,

I am creating a straight table in qlik view app.

There are 4 dimensions with string values in them.

I have already created a measure in the expressions and used the count aggregation with it.

Now, I need to find out the percentage of the count, out of the total sum of the count calculated.

 How can it be done?

[vinieme12]

that would be

count(YourField) / count(TOTAL YourField)

[vinieme12]

or sum of counts would be as below

count(YourField) / sum(TOTAL aggr(count(YouField),Dim1,Dim2,Dim3,Dim4))

[MayilVahanan]

HI

You can try with "relative" option also