topic i need to use monthend function and compare two field dates in QlikView

i need to use monthend function and compare two field dates

Fri, 06 Jun 2014 05:42:17 GMT

Hi,

REC_DAT <= 30.04.2014 & GR_DAT = “ ” or > 30.04.2014

in the place of date i need to use monthend function to get all the sum of the inventory that are present on the final day of the month

jonathandienst — Fri, 06 Jun 2014 05:49:32 GMT

Use

REC_DAT <= Date(MonthEnd(SomeDateField), 'DD.MM.YYYY')

HTH

Jonathan

Fri, 06 Jun 2014 05:59:46 GMT

Hi Jonathan

may be the data that i have provided is not enough

Fields:

REC_DAT Received Date

WERKS Plant

MATNR Material Number

INV_QTY Invoice Quantity – 3PL qty

PCN_DAT PCN date

GR_DAT GR Date

Logic

For 3PL stock as on 30.04.2014

REC_DAT <= 30.04.2014 & GR_DAT = “ ” or > 30.04.2014

For 3PL stock as on 31.05.2014

REC_DAT <= 31.05.2014 & GR_DAT = “ ” or > 31.05.2014

i need the sum of invoice quantity for each and every month