Showing data over the time

[Anonymous]

Hi Qlikview community,

Still familiarizing with Qlikview. I have a simple chart that I need to create, which can easily be created by excel but haven't been able to figure out with Qlikview.  It is a simple chart (e.g. scatter chart) to show data points over the time.

The data simply consists of 3 fields; Time Stamp, value 1, value 2.

While field 2 may contain many possible values, filed 3 is simply 4 possible values.

I'd like to simply create a chart with time stamp as dimension and value 1 as the expression.  I don't need to average the value 1, but simply show them in the chart. Another chart is  simply to show similar thing but with additional dimension (e.g. filed 3 as a second dimension).

What I did for the x- axis (dimension) is  Aggr(Timestamp(ceil(Time Stamp),1/IntervalName), 'DD-MMM-hh:mm'), [Time Stamp])

but it appears Qlikview  always requires aggregation function on the expression side.

Is there a way to simply show the relationship between the time and value 2 in the chart without aggregation function?

Also, can I do this with x/y or scatter chart instead of line chart?

Message was edited by: Fikri Shihab

[miguelbraga]

Hey there,

Can you share with us a sample of your Excel data so we can see what you want? Please try to describe better your issue, because its not that clear what you want to achieve.

Regards,

MB

[Anonymous]

Hi,

Sample data is attached and below is the expected chart that I created in Excel.

[MarcoWedel]

Hi,

some visualizations of your data might be:

tabSN:
LOAD RecNo() as ID,
    Timestamp#([Time Stamp],'DD/MM/YYYY hh:mm') as [Time Stamp],
    [User Name],
    Region,
    [Signal Quality]
FROM [https://community.qlik.com/servlet/JiveServlet/download/1122478-245214/Sample%20SN_data%20for%20Qlik...] (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

hope this helps

regards

Marco

[Anonymous]

Hi Marco,

This is really helpful. Many Thanks to you!

[MarcoWedel]

glad it helped.

please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

[Anonymous]

Hi Marco,

I know this is working but I am trying to to replicate exactly using the sample and hint provided.

No problem with line chart as did before.  Using aggregation (Avg) in the expression. 

Below are the steps that I did for scatter chart:

1. Select scatter chart
2. Used ID as dimension
3. Region as a  second dimension
4. X axis - Time Stamp (no aggregation)
5. Y-axis - Signal quality (no aggregation)
6. Change to advance mode
7. This is what shows up - changing the x axis to time stamp (using Number tab) did not change the chart

Something must be missing on my end. Sorry if this is too obvious for you

Also, it took very long to complete the above process.

My real data is over million records. Is there any way to expedite or simplify?

Thank you,

Fikri

[MarcoWedel]

Hi,

try deselecting the "Forced 0" option on the Axes tab

(  and maybe add some Static Min and Max expressions like Min([Time Stamp]) and Max([Time Stamp])  )

hope this helps

regards

Marco

[Anonymous]

Thanks, I finally managed to get it working

[MarcoWedel]

Glad it worked.

Please close your thread if your question is answered?

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco