Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

straight table/set analysis question

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

1 Solution

Accepted Solutions
IAMDV
Luminary Alumni
Luminary Alumni

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

www.QlikShare.com

View solution in original post

5 Replies
IAMDV
Luminary Alumni
Luminary Alumni

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

www.QlikShare.com

Not applicable
Author

This is what I am currently seeing is:

BHN Dept NameProblem ApptAll Appt
Patient Services4685401251589
Medicine4685401251589
Anesthesia4685401251589
Hospital Services4685401251589
Health Centers4685401251589
Cancer Services4685401251589
Surgery4685401251589
Emergency Services4685401251589
Womens Health4685401251589
Pediatrics4685401251589
Psychiatry4685401251589
Radiology4685401251589

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 StatusProb ApptsAll Appts
468,5401,251,589
No Show70,38370,383
Bumped77,52977,529
Canceled320,628320,628

I am not familiar with the GetCurrentField( groupname) function, I am not sure if I am using it properly.

Thanks

Not applicable
Author

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.

Not applicable
Author

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!

IAMDV
Luminary Alumni
Luminary Alumni

I'm glad you got it working.

Cheers,

DV

www.QlikShare.com