Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunflower_00
Contributor II
Contributor II

Data Disappear

Hi All,

I created a start time and end time in the load editor script. 

I did a set analysis in the front end  to extract the hours generated. However, the hours generated field returns zeros until I select one ID and then it returns the hours. 

What could be causing the hours generated filled to behave like this? 

 

Labels (3)
6 Replies
Or
MVP
MVP

This question is way too general to guess at the answer. I'd suggest posting the actual script and expression(s) used.

cristianj23a
Partner - Creator III
Partner - Creator III

Hi, More detail is required to be able to help you.

https://www.linkedin.com/in/cristianjorge/
Do not forget to mark as "Accepted Solution" the comment that resolves the doubt.
Sunflower_00
Contributor II
Contributor II
Author

Hi All 

Thank you for your responses. Let me try to provide more detail.

Load

starttime

starttime+ 30 as endtime

#hour

FROM---

In the front end I did this set analysis to extract the hours between starttime and endtime:

sum({$<timestamp={"=timestamp"<= endtime"}>}  #hours) 

It works but it returns null, I have to select an ID to get the  # hours.

 

 

menta
Partner - Creator II
Partner - Creator II

i think you need to aggregate data in set analysis

sum({$<timestamp={"=$(=Max(timestamp)) <= $(=Max(endtime))"}>}  #hours)

 

cristianj23a
Partner - Creator III
Partner - Creator III

Hi, try this code:

 

sum({$<timestamp={">=$(starttime) <= $(endtime)"}>} #hours)

 
https://www.linkedin.com/in/cristianjorge/
Do not forget to mark as "Accepted Solution" the comment that resolves the doubt.
Sunflower_00
Contributor II
Contributor II
Author

@menta  and @cristianj23a , thank you for your response. 

@menta, I tried your solution but  it doesn't change anything.

@cristianj23a , I also tried your solution and it returns the same number of hours as the #hours