topic Record not display completely in QlikView

Record not display completely

tracycrown — Wed, 07 Apr 2010 05:25:33 GMT

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

Record not display completely

tracycrown — Wed, 07 Apr 2010 05:27:59 GMT

Dear all

Atached is the excel data source.

Thank you. Tracy

Record not display completely

pablolabbe — Wed, 07 Apr 2010 05:44:37 GMT

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

Record not display completely

Wed, 07 Apr 2010 06:56:25 GMT

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

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

Record not display completely

Wed, 07 Apr 2010 08:15:47 GMT

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

Record not display completely

Wed, 07 Apr 2010 08:38:14 GMT

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.

Record not display completely

tracycrown — Thu, 08 Apr 2010 02:47:48 GMT

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