Variable for Days

[Anonymous]

• M_date  is avaiable where I need formulae M_date for a Delivered Product Vz Incorrect Product.
• Here I have to use the days not the months.The days start from current date (Today)
• actual month = last 30 days(variable which suits the Formulae)
• month before = last 30 days to last 60 days(variable which suits the Formulae)

[qlikviewwizard]

Hi,

Please use the below expression.

sum({<[Manufacturing date]={"<=$(=date(max([Manufacturing date])-60))"}>}SAL)

[jagan]

Hi,

Did you tried this

=Sum({<[Manufacturing year]=, [Manufacturing month]=, [Manufacturing date]={">=$(=date(max([Manufacturing date])-60)<=$(=date(max([Manufacturing date])-31)"}>} PosMenge)

Hope this helps you.

Regards,

jagan.