Summary in Qlikview using set analysis

[SK28]

Hi

Im having a data as shown below

Header 1	Header 2	complete tine for column HEADER 1(in hour)	STEP time based on Header 2
123	100	1.2	0.2
123	100.1	1.2	0.3
123	200	1.2	0.2
123	201	1.2	0.3
123	202	1.2	0.2
5688	100	5.6	1.2
5688	200	5.6	2.2
5688	300	5.6	0.6
5688	400	5.6	0.2
9989	100.1	2.3	1.1
9989	200	2.3	1
9989	300	2.3	0.1

This is the type of data I'm having where HEADER 1 TIME IS BASED  ON COLUMN 3 AND it will be same for one Unit

Whereas time of header 2 depends on Column 4

Expected Output:

Header 1	complete    time	sum of steps time
123	1.2	1.2
5688	5.6	4.2
9989	2.3	2.2

[vikramv]

Not sure if you are looking for the below one :

========

Load the data and create a Straight table chart with

Dimensions :

Header1

complete tine for column HEADER 1(in hour)

Expression :

Sum(STEP time based on Header 2)

[vishsaggi]

Where and why you want to use set analysis here? Try what vikram suggested. IF this is not what you looking for can you elaborate a little please.

[qlikviewwizard · Accepted solution]