topic Re: timestamps in QlikView

timestamps

raadwiptec — Fri, 09 Oct 2015 07:36:42 GMT

hi all,

I need timestamps filter

for eg: 24hrs timestamp

2015-08-20 12:45:31

2015-08-20 11:45:31

2015-08-20 20:45:31

2015-08-20 00:45:31 - midnight

2015-08-20 18:45:31

for example user need to have another option to see all the values after 6 pm in the evening

I need to filter timestamps if greater than '18 o Clock' . how could I do this using a button>?or is their a better way?

Re: timestamps

datanibbler — Fri, 09 Oct 2015 07:41:29 GMT

Hi,

timestamps are stored internally as a numeric decimal value.

=> You can use the FLOOR() and FRAC() functions to retrieve the date (left of the ,) or time (right of the ,).

=> Then you can use the DATE() or TIME() functions to format them as you like.

Using a button then to filter for all times greater than a certain time should after that be easy.

HTH

Best regards,

DataNibbler

Re: timestamps

Digvijay_Singh — Fri, 09 Oct 2015 07:59:43 GMT

Something like this -

Re: timestamps

raadwiptec — Fri, 09 Oct 2015 08:39:46 GMT

hi digvjay,

I used a slider as well but how do we link..is it through variable or just column

Re: timestamps

Digvijay_Singh — Fri, 09 Oct 2015 09:20:09 GMT

Just column field, I added expression =Time(frac(Timestamp),'hh:mm:ss') in the Field/expression of data section of slider. Selected Multi Value in Mode.

Re: timestamps

raadwiptec — Fri, 09 Oct 2015 12:09:08 GMT

in the script is it possible like if the time is greater than 6pm then a new column ..other than the filter option

Re: timestamps

Digvijay_Singh — Fri, 09 Oct 2015 16:36:06 GMT

It is possible but then you are fixing this column to show entry only greater than 6 pm, you will need script change if you need greater than any other time later.

load Timestamp, if(frac(Timestamp)>18/24,Timestamp) as After6PM;

load * inline [

Timestamp

2015-08-20 01:45:31

2015-08-20 02:45:31

2015-09-20 20:45:31

2015-10-20 18:45:31

2015-11-20 20:45:31

2015-11-20 18:45:31

2015-12-20 20:45:31

2015-12-20 00:45:31

2015-12-20 18:45:31

];

See if below option can suit you, you can create list box with greater than 6 pm entries through expressions -

sample qvw is attached -

Re: timestamps

Clever_Anjos — Fri, 09 Oct 2015 16:40:49 GMT

Please check if this logic fits to you

LOAD

Time,

Time(Round(Time,1/4)) as Flag; // This flag

LOAD

MakeTime(RecNo()-1,IterNo()-1) as Time // use your data here

AutoGenerate 24

While IterNo() < 60;

Re: timestamps

MarcoWedel — Sun, 11 Oct 2015 21:23:47 GMT

Hi raadwiptec‌,

please take some time to review and close those of your threads that have received correct answers.

(Your threads will be closed by marking an answer as correct.)

thank you

regards

Marco

Re: timestamps

MarcoWedel — Sun, 11 Oct 2015 21:31:38 GMT

Hi,

one solution using a button could be some "select in field" action with a search string like:

='=Frac(yourtimestamps)>''18:00:00'''

hope this helps

regards

Marco

Re: timestamps

raadwiptec — Mon, 12 Oct 2015 12:35:48 GMT

hi ,

Can u let me know how the same can be done between time

for ex: time 6pm to 6am in the morning in a variiable

Re: timestamps

Digvijay_Singh — Mon, 12 Oct 2015 14:04:11 GMT

See attached:

Re: timestamps

Digvijay_Singh — Mon, 12 Oct 2015 14:05:17 GMT

I think time has come to close/answer/mark helpful in this thread, you can open new one for new requirements.

Re: timestamps

raadwiptec — Mon, 12 Oct 2015 14:19:03 GMT

sure digvijay, I donno whom to point to correct answer...all have given good solutions..