Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Claudiu_Anghelescu
Specialist
Specialist

Interval between dates with variable condition

Hi,

I need a point, I want to calculate the interval between 2 dates for each ID.

For example I want to have the interval where Status=S1 and Status=S6, so 04/12/2019 - 06/12/2019.

table.png

But the status will be changed based on input variable.

 

A solution is to create a new Date field for each status in Load Script, but I want to sort out in a different way.

 

Thanks in advance!

To help community find solutions, please don't forget to mark as correct.
Labels (3)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

What about usin set analysis. 

See attached qvw file.

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
PrashantSangle

what is your expected w.r.t above data data...
Great dreamer's dreams never fulfilled, they are always transcended.
Vegar
MVP
MVP

What about usin set analysis. 

See attached qvw file.

image.png

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

Claudiu_Anghelescu
Specialist
Specialist
Author

The result is correct in the table but if I want to show it in a BarChart or TextBox, Only() is not working properly because aggregate at the lowest level.

To help community find solutions, please don't forget to mark as correct.