Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load problem

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:

Skärmavbild 2014-06-25 kl. 09.54.48.png

I only want to show the min P_TIME.

So i want to add "AND P_TIME minimum value"

Hope u understand me?!

13 Replies
alexandros17
Partner - Champion III
Partner - Champion III

A chart, with dimension and expression

alexandros17
Partner - Champion III
Partner - Champion III

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

Anonymous
Not applicable
Author

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;

Not applicable
Author

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.