topic Load problem in QlikView

Load problem

Wed, 25 Jun 2014 07:58:58 GMT

Hi, I have this problem that I dont know how to load this.

LOAD EMP,

P_DATE,

P_TIME,

P_TYPE

FROM

*****

WHERE EMP = '146' AND P_DATE = '2014-01-14' AND P_TYPE = 1;

this gets this:

I only want to show the min P_TIME.

So i want to add "AND P_TIME minimum value"

Hope u understand me?!

Re: Load problem

sujeetsingh — Wed, 25 Jun 2014 08:05:22 GMT

Use group by with required fields and then use Min(P_TIME) as AND P_TIME minimum value

Re: Load problem

MK_QSL — Wed, 25 Jun 2014 08:05:51 GMT

LOAD P_DATE,

MIN(P_TIME),

P_TYPE

FROM

****

WHERE EMP = '146' AND P_DATE = '2014-01-14' AND P_TYPE = 1

Group By P_DATE, P_TYPE;

Re: Load problem

alexandros17 — Wed, 25 Jun 2014 08:07:34 GMT

If you want to do in the script then write:

MYTAB_TMP:

LOAD EMP,

P_DATE,

P_TIME,

P_TYPE

FROM

*****

WHERE EMP = '146' AND P_DATE = '2014-01-14' AND P_TYPE = 1;

left join

Load EMP,P_DATE, min(P_TIME) as minimum

from

...

where

...

Group by EMP,P_DATE;

MYTAB:

noconcatenate

Load *, if(P_TIME=minimum, 1, 0) as flagmin resident MYTAB_TMP;

frop table MYTAB_TMP;

now you can use flagmin to show yourr data

Re: Load problem

selvakumarsr — Wed, 25 Jun 2014 08:08:16 GMT

Try where P_TIME =Min(P_TIME )

Re: Load problem

Wed, 25 Jun 2014 09:18:39 GMT

I get Invalid expression when i try to do like u said?

Re: Load problem

Wed, 25 Jun 2014 09:20:12 GMT

Thanks, but, with this I get 2 rows, with flagmin 1 on the row I want to display, the other row is still there but with flagmin 0..

I only want to get 1 row in the load result. how would i do that?

Re: Load problem

alexandros17 — Wed, 25 Jun 2014 09:25:42 GMT

Yes, you're right,

now in your chart write in the dimension EMP:

=If(flagmin=1, 'EMP', null())

and check the box suppress null values ....

let me know

Re: Load problem

Wed, 25 Jun 2014 09:26:31 GMT

Try this P_TIME =Min(P_TIME )..and else if you are facing the issue again then ckicl on this link..

Qlikview Courses, Training & Tutorial Online | Intellipaat.com

Re: Load problem

Wed, 25 Jun 2014 09:42:53 GMT

So i Should not use an Table Box?

Re: Load problem

alexandros17 — Wed, 25 Jun 2014 10:06:56 GMT

A chart, with dimension and expression

Re: Load problem

alexandros17 — Wed, 25 Jun 2014 10:09:06 GMT

Otherwise (if you don't need other values you could:

MYTAB_TMP:

LOAD EMP,

P_DATE,

P_TIME,

P_TYPE

FROM

*****

WHERE EMP = '146' AND P_DATE = '2014-01-14' AND P_TYPE = 1;

Inner join

Load EMP,P_DATE, min(P_TIME) as P_TIME

from

...

where

...

Group by EMP,P_DATE;

In this way you can use a table too, having only minimum values

Re: Load problem

Anonymous — Wed, 25 Jun 2014 10:16:53 GMT

Try below,

LOAD EMP,

P_DATE,

P_TYPE,

Min(P_TIME) as P_TIME

FROM

*****

WHERE EMP = '146' AND P_DATE = '2014-01-14' AND P_TYPE = 1

GROUP BY EMP, P_DATE, P_TYPE;

Re: Load problem

Wed, 25 Jun 2014 10:21:22 GMT

Hi,

Did u try adding another condition to your existing query, like below;

LOAD EMP,

P_DATE,

P_TIME,

P_TYPE

FROM

*****

WHERE EMP = '146' AND P_DATE = '2014-01-14' AND P_TYPE = 1

AND P_TIME=MIN(P_TIME);

Regards.