Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Relative percentage

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

Can you help?

Thanks.Relative.JPG

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Relative percentage

hei

see the attch example

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: Relative percentage

hei

see the attch example

View solution in original post

Highlighted
Partner
Partner

Relative percentage

Perfect!!!

Thank you.

Highlighted
Contributor II
Contributor II

Re: Relative percentage

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