topic Re: Handing timestamp in chart in QlikView

Handing timestamp in chart

Tue, 01 Sep 2015 18:36:03 GMT

Hi I have a timestamp field in my source data with 10 million approx distinct data.

There is only one straight table where i need to display this timestamp value in my qvw.

Now we have read in community that to optimize the performance of the qvw application we should not use the timestamp instead use the date .

Could someone please suggest a way to use this timestamp field with more

Note: i am using the date of the time stamp to link with my calendar and using this timestamp value in only one straight table

sunny_talwar — Tue, 01 Sep 2015 18:45:06 GMT

May be this blog will be helpful: The Master Time Table

Best,

Sunny

MarcoWedel — Tue, 01 Sep 2015 18:50:59 GMT

‌maybe helpful:

regards

Marco

rwunderlich — Tue, 01 Sep 2015 19:28:33 GMT

Break the timestamp into two separate fields -- Date and Time, using script such as this:

date(floor(mytimestamp)) as MyDate,

time(frac(mytimestamp) as MyTime

-Rob