Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

robbiewottie
New Contributor II

Dataset manipulation

Hi Guys,

I need to manipulate the following dataset with a set analysis in the front end or sort of calculation in the back end.

I have flags in fields for calculating movements.  But now need to change the flags of the last counter date (=always the last Day of the Month,)

As you can see is that this movement of the last day of the Month should be manipulated to Counter Date+1 and that the current record actualty didn't happend...I should be placed

Orginal dataset:

Counter Date      %OrderLineID      _Cont_Move_NEG           _Qty_Saldo_WEEK

04/06/2017           101368                            -                                              1

11/06/2017           101368                            -                                               1

18/06/2017           101368                           -                                                1

25/06/2017           101368                           -                                                1

30/06/2017           101368                           -1                                              0

New / Output Dataset:

Counter Date      %OrderLineID      _Cont_Move_NEG           _Qty_Saldo_WEEK

04/06/2017           101368                            -                                              1

11/06/2017           101368                            -                                               1

18/06/2017           101368                           -                                                1

25/06/2017           101368                           -                                                1

30/06/2017           101368                           -                                                1

01/07/2017           101368                           -1                                              0


--


I was thinking about inter record function (backend or a rangsum frontend)

Every advice is welcome!

Kind regards

Robbie





Tags (1)