topic Re: Sum of all values of a field in QlikView

Sum of all values of a field

Thu, 26 Jun 2014 12:31:37 GMT

Hello everyone,

I am asking your help about how can I automatically doing the count of lines of all the values of a field, to display it by percent.

For exemple, I have my field Code :

And the result is a chart, with the sum of lines with A, lines with B and lines with C, for a total of 100% :

Do you know if it is possible ?

Hope I was understandable.

Thanks !

yduval75 — Thu, 26 Jun 2014 12:34:35 GMT

Add an expression with Count (YourField) / Count (TOTAL YourField)

Thu, 26 Jun 2014 12:42:11 GMT

You can use stacked bar chart. If 'Code' is you only dimension, add dummy dimension before it.

Thu, 26 Jun 2014 13:44:44 GMT

Thanks for you responses.

I think I will do that.

Create all the expressions and use the stacked bar.

The only thing is that it will not be optimized when adding new values in the fields.

See you

santharubban — Thu, 26 Jun 2014 14:00:03 GMT

try this 100% chart

sum(fabs(COMMENROLL_ENROLLTYPE_GRP_COUNT))
/sum(total <COMMENROLL_ENROLLTYPE_DATE> fabs(COMMENROLL_ENROLLTYPE_GRP_COUNT))