topic Re: Table result error in QlikView

Table result error

Wed, 25 Nov 2020 16:16:04 GMT

When I select the below criteria individually the results are OK. Attached is the QVD file.

First Criteria Second Criteria

But when I combine the selection, some of the result is wrong : e.g. the OMSPO# 00012800’s FStatusDate is 03/12/2015, but it supposed to be 04/12/2015 if you execute the first criteria.(which is correct) .Thank you.

Appreciate someone could help.

Regards,

AG.

Re: Table result error

ramasaisaksoft — Mon, 28 Mar 2016 11:59:18 GMT

Hi Andros,

in your attachment qvw file Test tab what you want in Chart?

Once u select the Track mode as BookCNFRE then it is giving different results means may be you don't have data for that Track mode or else you need to change your expressions according to that selection also.

Re: Table result error

swuehl — Mon, 28 Mar 2016 13:02:48 GMT

I can't see OMSPO# 00012800 in your test date, I can see OMSPO# 128000 with a status date 25/01/2016 though.

Not sure how I can tell what's right and what's wrong. You would need to tell us a little more about your requirements.

Re: Table result error

imrencimen — Mon, 28 Mar 2016 13:26:20 GMT

OMSPO# is "000012800"

Your Expression is ;

=MIN(StatusDate)

İf u select all Track kode

min status date=03/12/2015.

OMSPO#	StatusDate	StatusDateF	trackCode
000012800	03/12/2015	03/12/2015	BOOKED
000012800	04/12/2015	03/12/2015	BOOKCONFRE

Re: Table result error

Tue, 29 Mar 2016 06:16:36 GMT

Hi imren,

Not the BOOKCONFRE captured 03/12/2015 as it captured 03/12/2015 as the MIN statusDate.

I think I know the problem, the criteria should be :

1. PO with Trackcode : BOOKED linked to TransportMode : B & V only
2. PO with TrackCode : BOOKCONFRE linked to TranspoprtMode : S, C, P, T only

3. Basically I need 3 reports : BOOKED, BOOKED and Combination of BOOKED & BOOKCONFRE.

4. But Currently, I can generate 2 separate reports (select BOOKED, B,V Or BOOKCONFRE, S,C,P,T) but not both as BOOKCONFRE also has TransportMode B & V in which I should exclude from the report.

5. And in each PO, they have multiple dates and I should take the first StatusDate (MIN(statusDate).

So how should I change the script to se the 2 cateria ?

Appreciate your help.

Thank you.

Regards,