Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
soniasweety
Valued Contributor III

Percentage

Hi all,

I want to do calucalte the cumulative % .

how can I achieve this?

I have a combo chart

dimension: sample Code

Exp:

1) count(product)    for bar chart

how can I write for  cumulative %  expression?

1 Solution

Accepted Solutions
ishanbhatt
Contributor II

Re: Percentage

For your information you have to also change the number format of the expression. you have to change the number format 'AUTO' to "Number' and in number format select percentage.

Steps:

  1. Apply Expression: Rangesum(Above(Count(Product),0,RowNo()))/Count(TOTAL Product)
  2. Change Number Format : Number -> Percentage->12%

Ishan.

10 Replies
Not applicable

Re: Percentage

In presentation tab there is option called

full Accumulation ,pls try with that

sarvesh
Contributor III

Re: Percentage

Hi.. Soni,

As per your requirement, you can use this code :

=COUNT(DISTINCT Customer)/COUNT(TOTAL DISTINCT Customer)

Regard's

Sarvesh Srivastava

ishanbhatt
Contributor II

Re: Percentage

Hi Sony,

I think you used qliksense. Hence, It is quit difficult to write Cumulative expression.

You can used below expression for cumulative in sense.

In my app I wanted Gross Sales Cumulative. I've used Rangesum function.

Rangesum(Above(Sum(GrossSales),0,RowNo()))/Sum(TOTAL GrossSales)

OR for your expression used below defined expression.

Rangesum(Above(Count(Product),0,RowNo()))/Count(TOTAL Product)

May be this will helps you.

Thanks,

Ishan

ishanbhatt
Contributor II

Re: Percentage

Hi Sony,

I've used above defined expression to find Cumulative percentage. If you wants only Cumulative of product count then used only first half of the expression.

Ex.

Rangesum(Above(Count(Product),0,RowNo()))

Thanks,

Ishan

soniasweety
Valued Contributor III

Re: Percentage

thanks all  but none of the expression is not workingSmiley Sad

cumulative% is showing more than 100%

like 255%,154%...

ishanbhatt
Contributor II

Re: Percentage

Hi Sony,

Can you provide source file of your data. So I'll try at my end.

ishanbhatt
Contributor II

Re: Percentage

For your information you have to also change the number format of the expression. you have to change the number format 'AUTO' to "Number' and in number format select percentage.

Steps:

  1. Apply Expression: Rangesum(Above(Count(Product),0,RowNo()))/Count(TOTAL Product)
  2. Change Number Format : Number -> Percentage->12%

Ishan.

murliqlik
Contributor

Re: Percentage

Hi Sony,

Please find the attachment file.

Regards,

Murali Mohan .T

ishanbhatt
Contributor II

Re: Percentage

Hi Murli,

I think you attached qlikview app functionality in screenshot but Sony wants in Qliksense.

Ishan