variable issue

[rcorcoran]

Hi

I have a variable below that I am using in a chart in the dimension and the expressions to display calculated data.

this method has worked for me numerous times but for some reason it will only display down to the 41st line here and will go no further - is there an error in the code it is showing me Garbage after "," in the variable window or is there a limit to the number of rows like this you can put in a variable?

Thanks

'Direct Staff WTE',

'Direct Staff WTE Employment Threshold',

'Direct Staff WTE Employment Threshold Variance',

'Direct Staff WTE Employment Threshold Variance %',

'Distribution of Staff - Medical/Dental',

'Distrubution of Staff - Nursing',

'Distribution of Staff - Health and Social Care Professionals',

'Distribution of Staff - Mgt/Admin',

'Distribution of Staff - General Support',

'Distribution of Staff - Other Patient + Client Care',

'2016 Development posts',

'2016 Development posts filled',

'% 2016 Development posts filled',

'pre-2016 Development posts filled',

'Direct Staff Headcount',

'WTE Starters YTD',

'WTE Leavers YTD',

'Quarterly Turnover Rate',

'Agency WTE conversion to Direct Staff YTD',

'Absenteeism - Medical /Dental',

'Absenteeism - Nursing',

'Absenteeism - Health & Social Care',

'Absenteeism - Management Admin',

'Absenteeism - General Support Staff',

'Absenteeism - Other Patient & Client Care',

'Absenteeism - Overall',

'Variance  Absenteeism - Medical /Dental',

'Variance Absenteeism - Nursing',

'Variance Absenteeism - Health & Social Care',

'Variance Absenteeism - Management Admin',

'Variance Absenteeism - General Support Staff',

'Varaince Absenteeism - Other Patient & Client Care',

'Variance Absenteeism - Overall',

'% Variance Absenteeism - Medical Dental',

'% Variance Absenteeism - Nursing',

'% Variance Absenteeism - Health Social Care',

'% Variance Absenteeism - Management Admin',

'% Variance Absenteeism - General Support Staff',

'% Varince Absenteeism - Other Patient & Client Care',

'% Variance Absenteeism - Overall',

'Absenteeism % Certified',

'Direct Staff WTE',

'Direct Staff WTE Employment Threshold',

'Direct Staff WTE Employment Threshold Variance',

'Direct Staff WTE Employment Threshold Variance %'

[Gysbert_Wassenaar]

Can you post a small qlikview document that explains what you're talking about. Because I have no idea what you posted and what the problem is?

[rcorcoran]

Hi Gysbert

I actually figured out the problem - two of the statements in the variable were the same so it stopped working where the second one came into the equation.

Thank you for your reply though

Rhona