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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mazacini
Creator III
Creator III

Create new column from specific row entries in old column

How can I take this data

13/08/201214.15
16/08/20128.18
17/08/201212.22
John Doe34.55
14/08/20128.47
15/08/20124.58
16/08/20129.39
17/08/201212.04
18/08/201210.19
19/08/20120.01
AN Other45.48
15/08/20125.3
15/08/20129.16
16/08/201210.08
17/08/201211.15
18/08/201212.15
19/08/2012
Mr X48.24

and make it load like this?:

John Doe13/08/201214.15
John Doe16/08/20128.18
John Doe17/08/201212.22
AN Other14/08/20128.47
AN Other15/08/20124.58
AN Other16/08/20129.39
AN Other17/08/201212.04
AN Other18/08/201210.19
AN Other19/08/20120.01
Mr X15/08/20125.3
Mr X15/08/20129.16
Mr X16/08/201210.08
Mr X17/08/201211.15
Mr X18/08/201212.15
Mr X19/08/2012
2 Replies
manojkvrajan
Luminary
Luminary

Mazacini, What is the association between John Doe, AN Other and Mr. X with the Date column?

mazacini
Creator III
Creator III
Author

Hi Manoj

In the first table, the first 3 entries are values (hh:mm) per day for John Doe,which are then totalled against his name in Line 4.

Lines 5 to 10 are the entries for An Other, which are then totalled on Line 11.

The table is an extract from a much larger table, where a full years data might appear for each name.

I hope I have explaned it properly.

Joe