Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted

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

Highlighted

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.