topic Summary in Qlikview using set analysis in QlikView

Summary in Qlikview using set analysis

SK28 — Wed, 25 Nov 2020 16:16:04 GMT

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:

vikramv — Sat, 09 Jun 2018 20:27:19 GMT

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 — Sat, 09 Jun 2018 21:31:09 GMT

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 — Mon, 11 Jun 2018 02:24:26 GMT