finding data for missing date

Bhagwat09 — Sat, 16 Nov 2024 16:52:59 GMT

Hello @hic

I have one table name DAT . On every monday and thursday data is uploaded in it but with same count [ 36k rows were added on every monday and thursday]. it consist 4 fields

for ex 16-6-2021 thursday

coulmn 1 date 2 origin_area 3 dest_area 4 rates KEY (created by me)

data 16-6-2021 MU_FT GT_OI 3.4 (16-6-2021 MU_FT- GT_OI)

16-6 -2021 MU_GY GT_PO 3.6 (16-6-2021 MU_GY -GT_PO)

It Is basically the rates that were added every time on Monday and Thursday with fixed no of rows.

but I have no data for like date 17,18,19 as there is no such date present .

So basically I need dates and data for 17 18 19 which should be same for 16 th date . then on monday on 20th new rates will come So again I want those data to be replicate for 21 22?

MinMaxTable:
Load
Max(date) as Maxdate,
Min(date) as Mindate
Resident [DAT];

Let vMax= Peek('Maxdate',0,'MinMaxTable');
Let vMin= Peek('Mindate',0,'MinMaxTable');

Drop Table MinMaxTable;

Calender:
Load
date($(vMin) + RowNo()-1) as X
AutoGenerate $(vMax) - $(vMin)+1;

I am working with above code for missing dates

Please help

Thanks

Re: finding data for missing date

maxgro — Fri, 17 Dec 2021 21:09:31 GMT

You can find the answer here

https://community.qlik.com/t5/Qlik-Design-Blog/How-to-populate-a-sparsely-populated-field/ba-p/1470637

topic finding data for missing date in App Development

finding data for missing date

Re: finding data for missing date