Need Sample Data For QlikSense

[Gtiwari01]

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

[yukler]

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

[Tanish]

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...

[Tanish]

Hi,

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