Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
skkrishna
New 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
Honored Contributor II

Re: Summary in Qlikview using set analysis

3 Replies
vikky
Contributor III

Re: Summary in Qlikview using set analysis

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
Esteemed Contributor III

Re: Summary in Qlikview using set analysis

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
Honored Contributor II

Re: Summary in Qlikview using set analysis