Help with writing script based on Inline view

helen_pip — Tue, 15 Jan 2013 13:51:05 GMT

Hello

I have a table which I originally built upon an inline view and wrote the expression in the pivot table to show the data. Example is below

(This is an example of what is a much larger inline table in reality)

Old Version

InLine View

Inline_MAINED:

LOAD * INLINE [

'Level Order', Level1, Level2, Level3, Level4, Level5

'3', 'TOTAL TIME SPENT IN DEPT',' NON ADMITTED', '95TH CENTILE', '<=04:00', 'CURRENT MONTH'

];

I then built a pivot table and wrote the following in the expression, but before long it became too large to work efficiently

Expression in pivot table

//NON ADMITTED: CURRENT MONTH

if(Level2='NON ADMITTED' AND Level5 = 'CURRENT MONTH',

Time(Fractile({<RunMonth = {$(=Max(RunMonth))}, [Patient Admitted?]={"0"} >}[Total Wait],0.95)/1440, 'hh:mm')

New Version

I then went back to my script and tried rewriting the necessary information in the script I.e.

Inline View

LOAD *, autonumber(Level1&'#'& Level2&'#'& Level3&'#'& Level4&'#'& Level5,'Inline_Monthly_Key_Overview') as Inline_Monthly_Key_Overview INLINE [
'Level Order', Level1, Level2, Level3, Level4, Level5,

'3', 'TOTAL TIME SPENT IN DEPT',' NON ADMITTED', '95TH CENTILE', '<=04:00', 'CURRENT MONTH'

];

Script

Inline_MAINED:

load

autonumber('TOTAL TIME SPENT IN DEPT' &'#'&'NON ADMITTED' & '#' &'95TH CENTILE' &'#' & '<=04:00' &'#' & 'CURRENT MONTH','Inline_Monthly_Key_Overview') as Inline_Monthly_Key_Overview,

RunMonth = Max(RunMonth) as Inline_Monthly_Overview_MonthYear,

[Total Wait] as Inline_Monthly_Data_C,

'EDE' as Inline_Monthly_DataSource

Resident main_data

where 'MAIN_EDE_PostQVD' = data_source

and [Patient Admitted?]=0

Expression in pivot table

=if (Level3='95TH CENTILE',time(Fractile(Inline_Monthly_Data_C,0.95)/1440,'hh:mm'))

However I cannot get it working....Could someone kindly cast an eye over the scripting to see what amendments I need to get working, especially around the set analysis for current month

Any ideas?

Kind Regards

Helen

topic Help with writing script based on Inline view in QlikView

Help with writing script based on Inline view