Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
brunolelli87
Creator II
Creator II

Set analysis - Average when date is equal to...

Hello guys,

I've a database with the following content and format:

DataAzul
23/03/2021 09:15:3332
23/03/2021 09:17:3330
23/03/2021 09:19:3335
23/03/2021 09:22:3339
......
24/03/2021 03:15:3332
24/03/2021 03:17:3330
24/03/2021 03:19:3335
24/03/2021 03:22:3339
......

 

So, as you can see, I'm basically collecting the Azul's value every two minutes...

 

My question is:

How can I create a chart in order to show:

Time (from 00:00:00 to 23:59:59) as my X axle - Dimension
Average of Azul as my Y axle PER DAY - Expression

So, my chart should look something like this:

brunolelli87_0-1616620043609.png

How can I do that?

Thanks

1 Solution

Accepted Solutions
MayilVahanan

HI @brunolelli87 

Bring time field from script like 

Load *, time(Data) as TimeData, Date(floor(Data),'DD/MM/YYYY') as Date from ursource;

In front end, 

Dim: TimeData

Exp1: Sum({<Date ={"$(=Date(Max(Date),'DD/MM/YYYY'))"}>}Azul)

Exp2: Sum({<Date ={"$(=Date(Max(Date)-1,'DD/MM/YYYY'))"}>}Azul)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

HI @brunolelli87 

Bring time field from script like 

Load *, time(Data) as TimeData, Date(floor(Data),'DD/MM/YYYY') as Date from ursource;

In front end, 

Dim: TimeData

Exp1: Sum({<Date ={"$(=Date(Max(Date),'DD/MM/YYYY'))"}>}Azul)

Exp2: Sum({<Date ={"$(=Date(Max(Date)-1,'DD/MM/YYYY'))"}>}Azul)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
brunolelli87
Creator II
Creator II
Author

Thank you so much!

I really appreciate your help!