Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

juan_escobar
Contributor II

Graphic by hours/day/month/year

Hello,

I have this table (is attached) and I want to make a barchart with each "presion (psi)" and another chart with "Q (lt/s)... the dimensions are all the time values.

How can I create these charts, drawing each point of the table vs time/date.

Apologies, I've just attached the file.

4 Replies
Not applicable

Graphic by hours/day/month/year

Hi,

no attachment in your post.

chandashok
Contributor III

Re: Graphic by hours/day/month/year

Hi Juan,

     Hope the following attached file will be helpful for your requirement

Regards

Ashok

juan_escobar
Contributor II

Graphic by hours/day/month/year

Ok, that worked, but now if you look closer to the date/time field I have data each 15 minutes, so 4 fields each hour... I need to get the average of the "presión" and "Q" by hour and then put it in a separate charts.

Is there any scrip or set analysis for that?

Thank you very much.

juan_escobar
Contributor II

Re: Graphic by hours/day/month/year

Hello,

all I needed was solved by using hour(Hora), and that gave me just the time sharp.

Now, I need to draw Presion (MCA) and Q(lt/s) in the X axis the hour and in the Y axis the amount, but I need ALL the months drawed as the Presion (MCA) graph alone and the Q(lt/s) alone. Now Mixed!

I attach a file with this