topic Re: Line Chart help in QlikView

Line Chart help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello Community,

I need help with a Line Chart

I have a table like this with a similar data

and when i'm trying to do a line chart that reflect the peack for every day in a date range I get something like this

I need to look something liket this

can someone help me, i dont know what to put in the expresion to make it look it like this one, im new to QlikView

Re: Line Chart help

buzzy996 — Fri, 02 Feb 2018 15:46:43 GMT

pls share sample qvw with ur data.

Re: Line Chart help

Anonymous — Fri, 02 Feb 2018 18:02:38 GMT

I can't the data come from a private base data via odbc connector with credentials

Re: Line Chart help

vishsaggi — Fri, 02 Feb 2018 18:24:17 GMT

What is the expression you are using in your line chart. Like Sum(yourfieldname) ?

Re: Line Chart help

Anonymous — Mon, 05 Feb 2018 13:41:53 GMT

for now im using avg(nr_vaule)/1000 , nr_value is a data that is a electronic pulse each 15mim , and the peak power that you see on the the table is the max pulse of the day