Previous 28 days in Qlikview

[Anonymous]

Hi guys,

i would like to do a count of orders for the previous 28 days in an expression. 

I have a day field in my load script called orders_invoice_date_day and the field i would like to count is order_no

Can this be done?

Thanks!

[julian_rodriguez · Accepted solution]

Hello Jamel

Try this:

Count({<orders_invoice_date_day = {'>=$(=Max(orders_invoice_date_day)-28)'}>}  order_no)

Regards

[jpenuliar]

Hi,

Try something like:

=COUNT(if([Date_In] >= DATE($(vStartDate)) And  [Date_In] <= DATE($(vEndDate)), COUNTER)) ,

the formula above assumes you have a two variables, vStartDate and vEndDate.

vEndDate can be by default = today(), or any dates selected. this depends on your design requirements.

set analysis can also work.

Regardsm,

JP

[Anonymous]

Julian's suggestion has worked !

Thanks very much..

[julian_rodriguez]

You are welcome... !