Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Minute value trending


In my dashboard I want to see a value trending in time.

Each minute we get a value out of the building management system.

For each sensor, in total 40 sensors, there is a text file with two parameters: Date and value


Date; Value

08-01-2015 15:06:00; 33

08-01-2015 15:07:00; 35

08-01-2015 15:08:00; 38

In the script the text file are combine together by the date.

For 1 month we have about 45.000 rows and 40 columns.

The problem is that the file is very slow and I thinks its due the script.

The file is attach.

Can you help me to make the file faster?


2 Replies
Not applicable

Re: Minute value trending

Hello Marcus,


I understand the principal but I can't get it in the script.

I tried the first one (the importance of being distinct) but it doesn't work.

Can someone pls help me to write the script in the attach file.