Discussion Board for collaboration related to Creating Analytics for QlikView.
Hello, I need the formula to calculate the relative percentage as shown in the %Relative image.
Can you help?
see the attch example
View solution in original post
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
I have put a condition in the expression(Txn_Count) formula that Status='failed' to get below:
Day Failure/success reason Txn_count
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