Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

adamgaleza
New Contributor

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;

Community Browser