Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QV Community,
I am having a problem with QV cooperating the way I want in a pivot table I am building. I am doing some analysis with Medical Claims utilization for a particular group of members and want to show some metrics for particular utilization types. For many of my calculations, I need to use the total members as the denominator but QlikView is just showing the sum of the members that had a claim of that particular type. My member counts are listed on a separate table than my claims table.
Does anyone have any suggestions to correct this? I essentially need QV to ignore the utilization type when totaling membership in this pivot table (thus making the value a constant for each row).
Thanks for any help anyone can provide!
Have your tried something like Sum(TOTAL Members)
can u post some sample data ?
Here is what is happening:
Claim Code Members
001 10
002 20
003 15
004 10
Total 55
Here is what I want it to show:
Claim Code Members
001 55
002 55
003 55
004 55
Total 55
I don't want QV to divide membership up by Claim Code (again, claims info is on one table and my membership info is on another). I need to show some % of total calculations on each line so that is why I need membership in total.
Here is what is happening:
Claim Code Members
001 10
002 20
003 15
004 10
Total 55
Here is what I want it to show:
Claim Code Members
001 55
002 55
003 55
004 55
Total 55
I don't want QV to divide membership up by Claim Code (again, claims info is on one table and my membership info is on another). I need to show some % of total calculations on each line so that is why I need membership in total.
Have your tried something like Sum(TOTAL Members)
use sum(total Members)
Thanks. This worked. I thought I already tried a sum total but I guess not.
I am new to QV so forgive me for the easy question!
Hi,
Did you try with TOTAL ?
ex :
count(TOTAL Member_Id)
or
sum(TOTAL Member_Field)
Hi,
there is no silly question. So dnt be sorry. we'all are learning here.
dnt frgt to Mark Answered
You just made the question difficult
Regards
Thanks everyone. All of these answers were correct. I marked correct answer for Nigel's response. Appreciate the quick feedback.