Data from last week

[george55]

Hi all,

It is possible to use an expressen / set analysis to range the data as follow:

Last week, beginning Monday till Friday or Sunday. E.g. today is 26 Feb. Need data: 17 - 21 Feb.

Thank for any advice.

[Qlik1_User1]

Yes possible try something like this..update YearStart(today()))<=$(=Today()) with desired data range

Count({<date= {">=$(=YearStart(today()))<=$(=Today())"}> } distinct id)

[george55]

I would say I am very closed, but did not get it to the end (see below). Had to say that I want to use it in a filter pane, so nothing to count. TimestampField is the Fieldname with timestamp-format in the filterpane.

thanks for any help.

=TimestampField = ">=(=WeekStart(Today(),-1)) < =(Date(WeekStart(Today(),-1)+4))"

[Qlik1_User1]

Try to do this in backend script to load only last week data

[george55]

And then?

The user have the posibility to explore all data. Would like to give him a simplification to see last week data. It is a possibility, not the only case

[Qlik1_User1]

Try this in filter pane

Aggr(Only({< numdate = {">=$(=vMin)<=$(=vMax)"} >}Date),Date)

[george55]

does not work

[bbmmouha]

hello 

i think that the problem is the timestamp

try to convert timestamp to Date 

like this Date ( timestampField , 'DD/MM/YYYY' ) >= ........... 

[Qlik1_User1]

share some sample data.

[george55]

As I told you I am very closed. It worked separately:

timestampField >= WeekStart(Today(), -1)
timestampField > Date(WeekStart(Today(), -1) +4)

The point is how to combine them.