topic Re: Simple data range question in Connectivity & Data Prep

Simple data range question

ksleini — Sat, 13 Nov 2021 14:43:23 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 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);

Re: Simple data range question

tresB — Fri, 12 Nov 2021 06:43:36 GMT

Like this?

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

AutoGenerate 365;

Re: Simple data range question

vinieme12 — Mon, 15 Nov 2021 07:34:11 GMT

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/1470637