Previous Date flag in script

rajinikanth — Sat, 16 Nov 2024 00:47:45 GMT

Hi I have dates as below

When I click on 21 aug 2019 date I need to see 03-sep-2019 data

when I click on 03-sep-2019 I need to see 11-oct-2019 data

Basically I need to create a flag in the script for my previous date like ISprevday =1

I need to do it in the script

Data	sales
21-Aug-19	100
03-Sep-19	200
11-Oct-19	300
01-Nov-19	400
02-Dec-19	500
02-Jan-20	600

Re: Previous Date flag in script

Saravanan_Desingh — Wed, 22 Apr 2020 22:54:36 GMT

Are you looking like this:

tab1: LOAD *, RecNo() As RowID INLINE [ Data, sales 21-Aug-19, 100 03-Sep-19, 200 11-Oct-19, 300 01-Nov-19, 400 02-Dec-19, 500 02-Jan-20, 600 ]; tab2: LOAD *, Peek('Data',RowID,'tab1') As NewData Resident tab1 ; Drop Table tab1;

topic Previous Date flag in script in QlikView

Previous Date flag in script

Re: Previous Date flag in script