Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
SK28
Creator
Creator

Summary in Qlikview using set analysis

Hi

Im having a data as shown below

Header 1Header 2complete tine for column HEADER 1(in hour)  STEP time based on Header 2
1231001.20.2
123100.11.20.3
1232001.20.2
1232011.20.3
1232021.20.2
56881005.61.2
56882005.62.2
56883005.60.6
56884005.60.2
9989100.12.31.1
99892002.31
99893002.30.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
1231.21.2
56885.64.2
99892.3

2.2

1 Solution

Accepted Solutions
qlikviewwizard
Master II
Master II

3 Replies
vikramv
Creator III
Creator III

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
Champion III
Champion III

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
Master II
Master II

Capture.PNG