Qlik Community

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

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

View solution in original post

3 Replies
Highlighted
Chanty4u
Esteemed Contributor III

Re: total sales based on timestamp

use timestamp as now()

it will give the exaxt time as

now.png

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

View solution in original post

Highlighted
Not applicable

Re: total sales based on timestamp

Thanks Henric for your help.