Problem with pivot table and providing a list box

helen_pip — Thu, 23 May 2013 11:59:45 GMT

Hello

I am struggling to get something new I need to add to work in my

pivot table

My data is at the lowest granularity and is at person level

I have built an inline statement in my script

Part of my in_line statement is:

Inline_Monthly:LOAD *, autonumber(Level1_Month&'#'& Level2_Month&'#'& Level3_Month&'#'& Level4_Month,'Inline_Monthly_Key') as Inline_Monthly_Key INLINE [
'Level Order_Month', 'Levela Order_Month', Level1_Month, Level2_Month, Level3_Month, Level4_Month,

3, 1, 'TOTAL TIME SPENT IN A&E DEPT','ADMITTED', '95TH CENTILE', '<=04:00'

I then start looking at my in_line statement and start assigning data

concatenate

(Inline_Monthly_Data)
loadautonumber

('TOTAL TIME SPENT IN A&E DEPT' &'#'&'ADMITTED' & '#' &'95TH CENTILE' &'#' & '<=04:00','Inline_Monthly_Key') as Inline_Monthly_Key,
MonthYear as Inline_Monthly_MonthYear,
[Total Wait] as Inline_Monthly_Data_A,
'ED' as Inline_Monthly_DataSource
Resident main_data
where 'MAIN_ED_PostQVD' = data_source
and [Patient Admitted?]=1

and ED_Adult/Paeds = 'Adult'

;

I then have a pivot table which references the assigned auto number:

if (Level3_Month='95TH CENTILE',time(Fractile({<Inline_Monthly_DataSource={ 'ED'} >} Inline_Monthly_Data_A,0.95)/1440,'hh:mm')

I have been asked to provide a list box where the user can select between Adult/Paediatrics, so I thought I would simply need to add an extra line to the script (Highlighted) in red and then right the script again, but where ED_Adult/Paeds = 'Paediatrics'

For some reason my efforts have not worked. Based on the information provided can anyone help me get this right so the user can select Adult or Paeds from a list box?

Thanks

Helen

topic Problem with pivot table and providing a list box in QlikView

Problem with pivot table and providing a list box