Relative percentage

analunasaucedo — Thu, 28 Jul 2011 10:00:10 GMT

Hello, I need the formula to calculate the relative percentage as shown in the %Relative image.

Can you help?

Thanks.

Re: Relative percentage

lironbaram — Thu, 28 Jul 2011 10:18:32 GMT

hei

see the attch example

Relative percentage

analunasaucedo — Thu, 28 Jul 2011 11:03:04 GMT

Perfect!!!

Thank you.

Re: Relative percentage

ankit_tikoo — Wed, 21 Feb 2018 14:07:34 GMT

I have a problem statement. I am from payment industry. Let me explain my problem

Day Failure/success reason Txn_Count

1 No funds 10

1 Cancelled 20

1 Not approved by bank 30

1 Successful 40

Total 100

I have put a condition in the expression(Txn_Count) formula that Status='failed' to get below:

Day Failure/success reason Txn_count

1 No funds 10

1 Cancelled 20

1 Not approved 30

I want Txn_count to be a relative percent i.e 10% for no funds, 20% for cancelled and 30% for not approved. This percent should be calculated with denominator 100 not 60

Also, This is for only on day. If there are many days and I select No funds failure reason, it should show relative share for all individual days.

1 No Funds 40%

2 No Funds 20%

3 No Funds 10%

Right now its showing 100% for all days. Can you help here

topic Re: Relative percentage in QlikView

Relative percentage

Re: Relative percentage

Relative percentage

Re: Relative percentage