topic Re: Need Sample Data For QlikSense in Data Movement & Streaming

Need Sample Data For QlikSense

Gtiwari01 — Wed, 19 Mar 2025 23:02:17 GMT

Hi All,

i was searching for Excel Data for Create a new data model, i need a relational data for excel minimum 10 tables in excel. each table should have relation to other table in same excel. i have searched but i can find only 1 table excel Data.

Can anyone help me 🙂

Thanks

Gautam

#relationaldata #exceldata #qliksense

Re: Need Sample Data For QlikSense

yukler — Fri, 04 Aug 2023 09:03:34 GMT

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

Re: Need Sample Data For QlikSense

Tanish — Fri, 04 Aug 2023 10:12:37 GMT

Hello GTiwari,

Here is the link, you can explore this excels.

https://drive.google.com/drive/folders/1oao42jnALXiFWLdLa0U8vuE92E26NaMy?usp=drive_link

Hope this will help...

Re: Need Sample Data For QlikSense

Tanish — Fri, 04 Aug 2023 10:15:27 GMT

Hi,

You can create a master calendar for this issue. It will generate all the date from starting till end.