topic Re: Hourly Evolution - Chart with last 24 values in QlikView

Hourly Evolution - Chart with last 24 values

Mon, 09 Nov 2015 12:56:54 GMT

I'm looking for a chart with the last 24 values according to an hourly evolution, in a real time database.

How can I do this?

Thanks!

Clever_Anjos — Mon, 09 Nov 2015 15:10:06 GMT

First of all you need to extract your data from your database

jyothish8807 — Mon, 09 Nov 2015 15:13:46 GMT

Hi Marcelo,

You can use dimension limit (Largest 24 values) or rank function in you chart to limit the latest 24 values.

may be u can use reloadtime() as a dimension to limit it or if you have a filed which changes on each load.

Regards

vishsaggi — Mon, 09 Nov 2015 15:18:27 GMT

Hello Marcelo,

Once you get the data as suggested by Clever Anjos...

Use the straight table and Add dimensions(Hourly Evolution) and expressions as per the requirement.

Then in the Dimension Limits Tab in straight table Restrict the values to Largest 24.

Snapshot attached.

Try and let us know if that works.

If you have any sample data file we can work on, that would be easy.

Thanks,