count previous week

nicki1926 — Tue, 22 Nov 2016 14:29:45 GMT

There 2 count numbers i would like to represent:

1) number of faults which happen today until a cretin hour.

2) number of faults which happen on the same day and hour a week before.

I'm having an issue with the 2nd count.

following my example:

lets say that now its 22/11/2016 10:00AM and i've create a count of faults starting from the begining of today untill now 10AM - alreay made this part

the problem start when i want to create a count of the 15/11/16 from begining of that day(15/11/16) untill 10AM.

here is the code i wrote:

variable:

$(v_seven_days) = date(MIN(fault_date) -7)

$(v_seven_days_hour)= hour(date(MIN(fault_date)-7 , 'dd/MM/yyyy hh:mm:ss') )

=count({<fault_date= {'$(=$(v_seven_days))'}, hour_falut= {'>=$(v_seven_days_hour) = hour(now()) '}>} fault_number)

but it's not working

topic count previous week in QlikView

count previous week