QlikView App Dev

[MaheshKharade007]

I am fetching data from Qvd with max number combined key. Numbers are 0,1,2,3,4,5,6 present in number field. But it showing only 1,2,3,4,5 numbers data. Following is the sample script. Thanks in Advance.

Mart:
LOAD

Distinct POL_NO&max(ENDOR_NUM) as polKey1%,
POL_NO,
max(ENDOR_NUM) as ENDOR_NUM_MAX

FROM
\\Path\Mart.qvd
(qvd) Group by POL_NO;

Left Keep(Mart)
LOAD 
Distinct POL_NO&ENDOR_NUM as polKey1%,
ENDOR_NUM,
MONTH,
LOCATION_NAME, 

BRANCH_NAME,
PUNCH_DATE

FROM
\\Path\Mart.qvd
(qvd);

[Brett_Bleess]

Likely going to need to attach QVW and QVD on this one for anyone to have a serious look at things and provide some ideas on what could be going wrong, rather difficult to say without those sources to dig into.  You could reduce the data in the QVD etc. to minimum needed to see the issue, but pretty sure that is going to be necessary in order to try to help given you have received no responses thus far.

Regards,
Brett