Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a straight table with one cycle group dimension (Hospitals, Division, Department, Provider, Patient etc....)
I have a couple of expressions:
Prob Appts: sum({$ <[Appt Status Code] = {'BMP', 'CAN', 'NOS'}>} CountAppt)
All Appointments: sum(CountAppt)
% Problem Appointments: [Prob Appts] / [All Appointments]
When I flip through the cycle group Division, Department, Provider, Patient are all working properly but Hospitals shows me the total number of appointments on every line. I am guessing that it is a formatting issue but if anyone can point me in the right direction it would be greatly appreciated!
Thanks,
Katie
Hi Katie,
What should be the expected result when you see Hospital as the dimension? Have you tried using GetCurrentField( groupname) function? This way you can control your expressions based on current dimension. Also, Is there a relationship (i.e. Hierarchy) between Hospitals, Division, Department, Provider & Patient?
Good luck!
Cheers,
DV
Hi Katie,
What should be the expected result when you see Hospital as the dimension? Have you tried using GetCurrentField( groupname) function? This way you can control your expressions based on current dimension. Also, Is there a relationship (i.e. Hierarchy) between Hospitals, Division, Department, Provider & Patient?
Good luck!
Cheers,
DV
This is what I am currently seeing is:
BHN Dept Name | Problem Appt | All Appt |
Patient Services | 468540 | 1251589 |
Medicine | 468540 | 1251589 |
Anesthesia | 468540 | 1251589 |
Hospital Services | 468540 | 1251589 |
Health Centers | 468540 | 1251589 |
Cancer Services | 468540 | 1251589 |
Surgery | 468540 | 1251589 |
Emergency Services | 468540 | 1251589 |
Womens Health | 468540 | 1251589 |
Pediatrics | 468540 | 1251589 |
Psychiatry | 468540 | 1251589 |
Radiology | 468540 | 1251589 |
The formula is putting the total in every row instead of breaking it down by department...
When I use the same formulas but a different dimension I am seeing the desired results:
Appt Status | Prob Appts | All Appts |
468,540 | 1,251,589 | |
No Show | 70,383 | 70,383 |
Bumped | 77,529 | 77,529 |
Canceled | 320,628 | 320,628 |
I am not familiar with the GetCurrentField( groupname) function, I am not sure if I am using it properly.
Thanks
Katie,
As Deepak said, the most probable reason for that behavior is that Hospital doesn't relate properly to the rest of the dimensions, so QlikView can't break the amounts correctly. Check the way this filed is relating to the rest of the data model.
Thanks guys, I don't think I understood Deepak's answer until now. You are both correct and I was able to find the break in the logic.
THANK YOU!