topic Re: straight table/set analysis question in QlikView

straight table/set analysis question

Mon, 01 Jul 2013 17:37:07 GMT

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

Re: straight table/set analysis question

IAMDV — Mon, 01 Jul 2013 18:36:54 GMT

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,

www.QlikShare.com

Re: straight table/set analysis question

Tue, 02 Jul 2013 12:45:12 GMT

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

Re: straight table/set analysis question

Tue, 02 Jul 2013 14:37:09 GMT

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.

Re: straight table/set analysis question

Tue, 02 Jul 2013 14:43:43 GMT

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!

Re: straight table/set analysis question

IAMDV — Tue, 02 Jul 2013 14:45:56 GMT

I'm glad you got it working.

Cheers,