# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save \$200. Learn More
Highlighted
Not applicable

## total sales based on timestamp

Hi Viewers,

I have a doubt.

Sum({<year={2015},month={'may'},weekday={'sun'}>}sales)

But how do we analyse total sales based on timestamp

Suppose we have timestamp 6:00pm for Sunday

Pls help me on this.

Tags (1)
1 Solution

Accepted Solutions
Employee

## Re: total sales based on timestamp

If you want a Set Analysis expressions picking out transactions after 6:00pm on Feb 21st, you can use

Sum({\$<Timestamp={">=2/21/2016 6:00pm"}>} Sales)

Just make sure to use the correct timestamp format. See Dates in Set Analysis

HIC

3 Replies
Highlighted
Esteemed Contributor III

## Re: total sales based on timestamp

use timestamp as now()

it will give the exaxt time as

Employee

## Re: total sales based on timestamp

If you want a Set Analysis expressions picking out transactions after 6:00pm on Feb 21st, you can use

Sum({\$<Timestamp={">=2/21/2016 6:00pm"}>} Sales)

Just make sure to use the correct timestamp format. See Dates in Set Analysis

HIC

Highlighted
Not applicable