Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

i need to use monthend function and compare two field dates

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

2 Replies
MVP
MVP

Re: i need to use monthend function and compare two field dates

Hi

Use

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



HTH

Jonathan



Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: i need to use monthend function and compare two field dates

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