Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MaheshKharade007
Contributor
Contributor

Max number combined key not returning 0

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);

Labels (1)
1 Reply
Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.