Record not display completely

[tracycrown]

Dear all

Kindly help to explain why 1st & 2nd records do not display properly in the report due to duplicate start date (Feb 5, 2010).

Thank you so much, Tracy

[tracycrown]

Dear all

Atached is the excel data source.

Thank you. Tracy

[pablolabbe]

Tracy,

When creating a chart object, all chart expression must have an aggregation function.

Put all your fields as dimensions and create and an expression "=sum(1)".

Or maybe you need to use Table Box Object to achieve the same result as shown in your Excel.

Good Luck

Pablo

[#4]

Tracy,

You have given dimension values under expressions. Hence you are getting this problem. Also in your script, I find you have renamed date([Start Date]) as 'Start Date'. This should written as date([Start Date]) as [Start Date]. Your script should be :

Step1:

//-----------------------------------------------------------------------

Directory;

LOAD

year([Start Date]) as Year,

month([Start Date]) as Month,

day

date

date

Recruiter

Department

Position

Plan

FROM

//-----------------------------------------------------------------------------------------

Step2: In your chart, the following dimensions should be used:

[Test-1.xls] (biff, embedded labels, header is 2 lines, table is Sheet1$); , , ,([Due Date]) as [Due Date], ([Start Date]) as [Start Date],([Start Date]) as Day,

Step3: In your expressions, put one one expression as sum(Plan).

Please let me know if it works fine as per the logic.

Thanks & Regards,

Vineet

[#5]

hi ,

pls use "position" as a dimension instead of an expression.

i have created one new chart in your application to illustrate this.

now it should work fine

thanks

[#6 · Accepted solution]

Hi Tracy,

You are using a straight table and giving position as a expression in that straight table. Now this doesn't work because QlikView gets confused on which value of the position must be displayed. This problem is solved in the application posted by tuqeer. He removed the expression 'position' and gave it as dimension in the chart. I hope this helps

Thanks.

[tracycrown]

Dear all,

I would like to thanks all experts who had given me so many advices and I really learn a lot from you all. As a beginner, I have a long way to go and I hope you all could continue to enlighten me in future.

Thank you very much indeed, Tracy