Simple data range question

[chaeunwoo]

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?

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-03-2023','DD-MM-YYYY') + 1);

[mshann01]

You'd want to create a master calendar in the load script.  This can be done a few different ways.  Here's a sample.

https://community.qlik.com/t5/QlikView-App-Dev/How-to-Create-Master-Calendar/td-p/103109