Minute value trending

[#1]

Hello,

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

Like:

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?

Thanks.

[marcus_sommer]

Have a look here:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/11/the-importance-of-being-distinct

http://community.qlik.com/docs/DOC-4597

- Marcus

[#3]

Hello Marcus,

Thanks.

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.

Thanks,

Ralph