Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

rummyvarma
New Contributor

show only 3pm data

I have timestamp column and I want to pick only 3 pm data from rest of data

3 Replies
oknotsen
Honored Contributor III

Re: show only 3pm data

Define "3pm".

  • Do you mean that exact millisecond?
  • Do you mean "the time between 15h00 and 15h59:59"?
  • Do you mean "the time between 14h58 and 15h02"
  • ...

There are various ways of doing this, but it all depends on what you exactly have in mind.

May you live in interesting times!
rummyvarma
New Contributor

Re: show only 3pm data

I have to show in column only 3.45pm,3.50pm like that

Re: show only 3pm data

Do you want to exclude the other times in the script? May be this

LOAD ....

FROM...

WHERE Hour(TimeStamp) = 15;

On the front end, you can try this

{<TimeStamp = {"=Hour(TimeStamp) = 15"}>}