topic Re: total sales based on timestamp in QlikView

total sales based on timestamp

Mon, 22 Feb 2016 05:51:27 GMT

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.

Chanty4u — Mon, 22 Feb 2016 08:12:58 GMT

use timestamp as now()

it will give the exaxt time as

hic — Mon, 22 Feb 2016 10:11:45 GMT

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

Mon, 22 Feb 2016 14:18:32 GMT

Thanks Henric for your help.