Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to join the Time field with two statements in one row?? - help

Hi everyone!

I have a problem with getting the first and last time fields where each of this field have exactly that same other fields.

My situation is like here:

example_problem.png

I had this problem before but with only dates.

Mainly this table had time in one field like u had last column here. i split states by BeaconState field in two columns and next concatenate the tables. What i can to do next to get the numbered fields in one row.? This is all information in table what i have.

i try to use firstvalue and group by other fields like ImieNazwisko, BeaconName (first column), BeaconState and Czas.

At the moment my last modified rows from Script:

NoConcatenate

KADRY_czas:

Load distinct

    BeaconName,

BeaconStatus,

Czas,

ImieNazwisko,

    firstvalue(Czas_start) as  Czas_start,

    LastValue(Czas_stop) as Czas_stop

Resident KADRY_podzial

Group By

BeaconName,

BeaconStatus,

Czas,

ImieNazwisko

Order By

ImieNazwisko,

Czas,

czas_start_row,

czas_stop_row,

BeaconStatus,

BeaconName

; Drop Table KADRY_podzial;

0 Replies