topic Simple data range question in Connectivity & Data Prep

Simple data range question

chaeunwoo — Thu, 20 Apr 2023 14:21:21 GMT

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);

Re: Simple data range question

mshann01 — Mon, 01 May 2023 13:12:02 GMT

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