Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Can anyone suggest me please..
how can I calculate total conversion rate %? i,e out of ten cases only one is missed.so, for Adam the quality is best. How can I mention that Adam is doing best by representing with conversion rate %? can anyone please suggest me.
for eg:
Employee name: Adam
Total cases=10
Total missed=1
This is urgent for me please.
Like this?
Update :
(SUM({<Total = {'Total cases'}>}Data)-SUM({<Total = {'Total Missed'}>}Data))/SUM({<Total = {'Total cases'}>}Data)
please see sample
I need to show for eg:
Adam has 10-1 =9 . so, need to show this 9 in percentage rate. Is it possible. can anyone help me?
Like this?
Update :
(SUM({<Total = {'Total cases'}>}Data)-SUM({<Total = {'Total Missed'}>}Data))/SUM({<Total = {'Total cases'}>}Data)
Thanks. You are 100 % right. How can I use to calculate the same in excel sheet with out using in qvw? Please let me know.
Something like enclosed
Perfect
Amelia - I'd strongly recommend you reading below two posts.
QlikCommunity Tip: How to get answers to your post?
Its not about the answer, rather it’s about the question…
Good luck!
Cheers,
DV