Simple data range question

[ksleini]

Hi guys,

i'm stucking ni this simple situation where i need ta have bars from a date range (2014-now) but not all date have data in them, how do i generate a local autogenareted table with a date range applinked?

in Oracle i would do someting like this:

SELECT

(to_date(sysdate,'DD-MM-YYYY') - level + 1) AS day

FROM

dual

CONNECT BY LEVEL <= (to_date(sysdate,'DD-MM-YYYY') - to_date('01-01-2014','DD-MM-YYYY') + 1);

[tresesco]

Like this?

Load  Date(Today()-365+RecNo())) as Date

AutoGenerate 365;

[vinieme12]

When you create a master calendar for your model, this problem will be solved automatically

https://qlikviewcookbook.com/2015/05/better-calendar-scripts/

alternatively look at this as well 

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