Pulling the correct Months data with IF statement

Anonymous — Tue, 26 Sep 2017 10:15:34 GMT

Hello all,

The image of the excel file below is Loaded into QV in order to connect the correct 'Boardcost' (C1) to the corresponding Date (B2).

QV is currently pulling the Date and Information from our Internal Database. I would like to write an IF expression in order to link the Excel and QV date and pull through the excel Boardcost.

The excel Date ranges from Jan-17 to Sep-17. The current expression i am looking for is similar to the one below (which doesn't currently work):

IF (TPCBoardgrade.Date < '01/02/2017', 'Jan-17',If(TPCBoardgrade.Date, > '31/01/2017' or < '01/03/2017' 'Feb-17', IF (TPCBoardgrade.Date, > '31/02/2017' or < '01/04/2017' 'Mar-17', IF (TPCBoardgrade.Date, > '31/03/2017' or < '01/05/2017' 'Apr-17', IF (TPCBoardgrade.Date, > '30/04/2017' or < '01/06/2017' 'May-17', IF (TPCBoardgrade.Date, > '31/05/2017' or < '01/07/2017' 'Jun-17', IF (TPCBoardgrade.Date, > '31/05/2017' or < '01/07/2017' 'Jul-17', IF (TPCBoardgrade.Date, > '30/6/2017' or < '01/08/2017' 'Aug-17'), 'Sep-17'))))))))

Any help in the expression above or recommendations would be greatly appreciated.

Regards,

Re: Pulling the correct Months data with IF statement

Anil_Babu_Samineni — Tue, 26 Sep 2017 14:25:38 GMT

Not sure, This is typo error. Try this?

IF (TPCBoardgrade.Date < '01/02/2017', 'Jan-17',

If(TPCBoardgrade.Date > '31/01/2017' or TPCBoardgrade.Date < '01/03/2017', 'Feb-17',

IF (TPCBoardgrade.Date > '31/02/2017' or TPCBoardgrade.Date < '01/04/2017', 'Mar-17',

IF (TPCBoardgrade.Date > '31/03/2017' or TPCBoardgrade.Date < '01/05/2017', 'Apr-17',

IF (TPCBoardgrade.Date > '30/04/2017' or TPCBoardgrade.Date < '01/06/2017', 'May-17',

IF (TPCBoardgrade.Date > '31/05/2017' or TPCBoardgrade.Date < '01/07/2017', 'Jun-17',

IF (TPCBoardgrade.Date > '31/05/2017' or TPCBoardgrade.Date < '01/07/2017', 'Jul-17',

IF (TPCBoardgrade.Date > '30/6/2017' or TPCBoardgrade.Date < '01/08/2017', 'Aug-17', 'Sep-17' ))))))))

topic Pulling the correct Months data with IF statement in QlikView

Pulling the correct Months data with IF statement

Re: Pulling the correct Months data with IF statement