Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hii good morning need a help
this is my table
HOSPITAL_NAME | HOSPITAL_CODE | CLM_XGEN_CLAIM_NUM | CLM_INTIMATION_DATE | Clm_Type | ICD_CODE_LEVEL1_org | total count of claims | ICD Code Blacklist | Value |
ADITYA HOSPITALS | HEGIC-HS-23852 | RR-HS15-10335372 | 01-Feb-2016 | REIMBURSMENT | R50.9 | 1 | 1 | 0.1000 |
ADITYA HOSPITALS | HEGIC-HS-23852 | RR-HS15-10335372 | 01-Feb-2016 | REIMBURSMENT | - | 1 | 0 | 0.1000 |
ADITYA HOSPITALS | HEGIC-HS-23852 | RR-HS15-10336083 | 05-Feb-2016 | REIMBURSMENT | S42.0 | 1 | 1 | 0.1000 |
ADITYA HOSPITALS | HEGIC-HS-23852 | RR-HS15-10336083 | 05-Feb-2016 | REIMBURSMENT | - | 1 | 0 | 0.1000 |
ADITYA HOSPITALS | HEGIC-HS-23852 | RR-HS15-10338653 | 22-Feb-2016 | REIMBURSMENT | N39.0 | 1 | 1 | 0.1000 |
ADITYA HOSPITALS | HEGIC-HS-23852 | RR-HS15-10338653 | 22-Feb-2016 | REIMBURSMENT | - | 1 | 0 | 0.1000 |
ADITYA HOSPITALS | Total | 3 | 3 | 0.3000 |
i want to divide ( individual ICD_CODE_LEVEL1_org /total count of claims )
eg :
R50.9/3
means 1/3=0.3333
i am getting a problem its dividing whole column as u can see i have mark it in yellow colour
so can any one help me in this !!!!!!
its not working
will give u table
HOSPITAL_NAME | HOSPITAL_CODE | CLM_XGEN_CLAIM_NUM | CLM_INTIMATION_DATE |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS15-10342246 | 15-Mar-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS15-10342246 | 15-Mar-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS15-10342248 | 15-Mar-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS15-10342248 | 15-Mar-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS15-10342249 | 15-Mar-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS15-10342249 | 15-Mar-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10346621 | 12-Apr-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10346621 | 12-Apr-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10347804 | 20-Apr-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10347804 | 20-Apr-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10349821 | 03-May-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10349821 | 03-May-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10349825 | 03-May-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10349825 | 03-May-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10349827 | 03-May-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10349827 | 03-May-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10349828 | 03-May-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | HEGIC-NN-14636 | RR-HS16-10349828 | 03-May-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCES | Total |
Clm_Type | ICD_CODE_LEVEL1_org | total count of claims | ICD Code Blacklist | Value |
REIMBURSMENT | C91.0 | 1 | 1 | 0.111 |
REIMBURSMENT | - | 1 | 0 | 0.000 |
REIMBURSMENT | C91.0 | 1 | 1 | 0.111 |
REIMBURSMENT | - | 1 | 0 | 0.000 |
REIMBURSMENT | C91.0 | 1 | 1 | 0.111 |
REIMBURSMENT | - | 1 | 0 | 0.000 |
REIMBURSMENT | N18.5 | 1 | 1 | 0.111 |
REIMBURSMENT | - | 1 | 0 | 0.000 |
REIMBURSMENT | C08.0 | 1 | 1 | 0.111 |
REIMBURSMENT | - | 1 | 0 | 0.000 |
REIMBURSMENT | C91.0 | 1 | 1 | 0.111 |
REIMBURSMENT | - | 1 | 0 | 0.000 |
REIMBURSMENT | C91.0 | 1 | 1 | 0.111 |
REIMBURSMENT | - | 1 | 0 | 0.000 |
REIMBURSMENT | C91.0 | 1 | 1 | 0.111 |
REIMBURSMENT | - | 1 | 0 | 0.000 |
REIMBURSMENT | C91.0 | 1 | 1 | 0.111 |
REIMBURSMENT | - | 1 | 0 | 0.000 |
9 | 9 | 0.333 |
C91.0 is repeated 7 times so it should go 7/9 and the ans but is divinding 1/9
Hi sagar,
You are not counting distinct.
If you want divide by total, write TOTAL on your Expression.
If you wanna count distinct values, write DISTINCT on your expression.
see i my table both are coming
in one hos[ital repeated data is coming but in another its not coming
now how to handle it
this is my table below
HOSPITAL_NAME | HOSPITAL_CODE | CLM_XGEN_CLAIM_NUM | CLM_INTIMATION_DATE |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE | HEGIC-NN-57847 | RR-HS16-10356311 | 10-Jun-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE | HEGIC-NN-67133 | RR-HS16-10354704 | 01-Jun-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE | HEGIC-NN-67133 | RR-HS16-10354704 | 01-Jun-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE | HEGIC-NN-67133 | RR-HS16-10354707 | 01-Jun-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE | HEGIC-NN-67133 | RR-HS16-10354707 | 01-Jun-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE | HEGIC-NN-67133 | RR-HS16-10354713 | 01-Jun-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE | HEGIC-NN-67133 | RR-HS16-10354713 | 01-Jun-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE | Total | ||
ALL INDIA INSTITUTE OF MEDICAL SCIENCE.. | HEGIC-NN-58922 | RR-HS15-10331196 | 05-Jan-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE.. | HEGIC-NN-58922 | RR-HS15-10331196 | 05-Jan-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE.. | HEGIC-NN-58922 | RR-HS15-10331196 | 05-Jan-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE.. | HEGIC-NN-58922 | RR-HS16-10349824 | 03-May-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE.. | HEGIC-NN-58922 | RR-HS16-10349824 | 03-May-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE.. | HEGIC-NN-58922 | RR-HS16-10356568 | 13-Jun-2016 |
ALL INDIA INSTITUTE OF MEDICAL SCIENCE.. | Total | ||
Clm_Type | ICD_CODE_LEVEL1_org | total count of claims | ICD Code Blacklist |
REIMBURSMENT | - | 1 | 0 |
REIMBURSMENT | C91.0 | 1 | 1 |
REIMBURSMENT | - | 1 | 0 |
REIMBURSMENT | C91.0 | 1 | 1 |
REIMBURSMENT | - | 1 | 0 |
REIMBURSMENT | C91.0 | 1 | 1 |
REIMBURSMENT | - | 1 | 0 |
4 | 3 | ||
REIMBURSMENT | K74.6 | 1 | 1 |
REIMBURSMENT | K92.2 | 1 | 1 |
REIMBURSMENT | - | 1 | 0 |
REIMBURSMENT | C91.0 | 1 | 1 |
REIMBURSMENT | - | 1 | 0 |
REIMBURSMENT | - | 1 | 0 |
3 | 3 | ||
Hi sagar,
Count(TOTAL <HOSPITAL_CODE> DISTINCT ICD_CODE_LEVEL1_org) for total distinct by hospital
Regards!
but there are too many hospital and codes given to it
then what to do
On Total, you can indicate for which groups you want to calculate totals, you only need to specify the group.
This expression will calculate all distinct ICD_CODE_LEVEL1_org for each Hospital.
Regards!
not getting can u give eg manuel
Hi Sagar,
From QV Help:
These examples are made with the sum([{set_expression}][distinct][total[<fld {, fld}>]] expression) function, but may be applied on all chart aggregation functions supporting Set Analysis definitions and the total qualifier.
Example 1:
Study the representation of a straight table below, depicting the logical state before any selections have been made:
The second and third expression column have the same number in all rows. This number equals the calculated total in the first expression column.
Now, let's select months 1 and 2 only. The result is as follows:
The result of the third expression (fifth column) remains unchanged because the set definition disregards current selections. The second expression (fourth column) with the total qualifier, shows the new total 10, which is still equivalent to the first expression total (third column).
Example 2:
Study the representation of a straight table below:
In the third expression column (sum(total<Month> Val)) one total is calculated for each month.
In the fourth expression column (sum(total<Grp> Val)) one total is calculated for each group.
Regards!