Discussion board where members can get started with QlikView.
I have written the following and it returns a value of 03:06
When I add this formula to a pivot table which has month across the top, the formula remains at 03:06 for every month
Could you kindly help me rewrite the formula so that it is not static and will change for every month in the pivot table
Try smthg like this:
=Time(RangeFractile(.5, $(=(If([Patient Admitted?]=1,[Total Wait]) & ',') & ',' & (If([ADMISSION_FLAG]='Y',CONCLUSION_WAIT_MINS) &','))
Thank you for your reply. I have been playing with this statement for a couple of days now, and cannot seem to get it to work
The above statement unfortunatley returns a null value
Do you have any additional ideas?