Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mazacini
Contributor 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
Contributor III

Re: Create new column from specific row entries in old column

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

mazacini
Contributor III

Re: Create new column from specific row entries in old column

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

Community Browser