Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
skkrishna
Contributor III
Contributor III

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