topic Set analysis - Average when date is equal to... in QlikView

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

brunolelli87 — Wed, 24 Mar 2021 21:09:22 GMT

Hello guys,

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

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:

How can I do that?

Thanks

MayilVahanan — Thu, 25 Mar 2021 06:33:15 GMT

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)

brunolelli87 — Fri, 26 Mar 2021 13:36:08 GMT

Thank you so much!

I really appreciate your help!