topic Re: Need sample DataBase for preparing some Qlikview reports. in QlikView

Need sample DataBase for preparing some Qlikview reports.

Thu, 24 Jul 2014 13:16:33 GMT

Hi Friend,

I am new to QlikView, can you please provide the sapmple data files like .xls, .mdb.

Thanks&Regards

Ramesh

Re: Need sample DataBase for preparing some Qlikview reports.

ashfaq_haseeb — Thu, 24 Jul 2014 13:18:36 GMT

Hi,

Have a look at below post.

http://community.qlik.com/docs/DOC-6032

Regards

ASHFAQ

Re: Need sample DataBase for preparing some Qlikview reports.

Thu, 24 Jul 2014 16:06:05 GMT

Hi Ramesh,

you can create your own data set in the below link. Check it out.

Mockaroo | Random Test Data Generator | CSV / TXT / SQL / JSON

Thanks

Re: Need sample DataBase for preparing some Qlikview reports.

engishfaque — Fri, 25 Jul 2014 06:56:54 GMT

Dear Ramesh,

Sure, here are the attached sample excel and ms access files for your practice and good understanding.

Please download the files.

Kind regards,

Ishfaque Ahmed

Re: Need sample DataBase for preparing some Qlikview reports.

avinashelite — Fri, 25 Jul 2014 06:58:58 GMT

Hi Ramesh,

You can also try creating your own inline tables and you can use that also as a source

Re: Need sample DataBase for preparing some Qlikview reports.

SunilChauhan — Fri, 25 Jul 2014 07:12:54 GMT

you could download by seraching sample data for sql server,Ms acceess or excels

Re: Need sample DataBase for preparing some Qlikview reports.

Fri, 25 Jul 2014 07:16:01 GMT

Hi Ramesh

hear i have attached proposed Slary_breakup.xls with formulas that you can import in you project and run the Report.

Re: Need sample DataBase for preparing some Qlikview reports.

amit_saini — Fri, 25 Jul 2014 07:20:15 GMT

Ramesh,

Try attached one.

Thanks,

Re: Need sample DataBase for preparing some Qlikview reports.

Fri, 25 Jul 2014 07:30:53 GMT

Hi Ishfaque,

Could please forward the excel and ms access files.

Thanks&Regards

Ramesh

Re: Need sample DataBase for preparing some Qlikview reports.

engishfaque — Fri, 25 Jul 2014 07:33:05 GMT

Dear Ramesh,

Kindly download attached file.

Kind regards,

Ishfaque Ahmed

Re: Re: Need sample DataBase for preparing some Qlikview reports.

Anonymous — Fri, 25 Jul 2014 09:31:01 GMT

There are loads of data source on the internet.

Here is an example loading a List of sovereign states and dependent territories by population density from Wikipedia.

LOAD Pos.,

[Country (or dependent territory)],

[Area (kmÂ²)],

[Area (miÂ²)],

Population,

[Density (pop./kmÂ²)],

[Density (pop./miÂ²)],

Date,

[Population source]

FROM

[http://en.wikipedia.org/wiki/Countries_by_population_density]

(html, codepage is 1252, embedded labels, table is @1);

In the script editor click on <Web Files> and you'll get a wizard to guide you through.

Here is another one getting weather data

////////////////////////////////

let vURL = 'http://api.openweathermap.org/data/2.5/forecast/daily?id=' & '$(vId)' & '&mode=xml&units=metric&cnt=14' ;

////////////////////////////////

Time:

////////////////////////////////

LOAD

$(vId) as id ,

date(day) as [Date] ,

weekday(date([Date])) as [Weekday] ,

MonthName(date(day)) as [Month Year] ,

Capitalize ( [clouds/value] ) as [Cloud Value] ,

[clouds/all]/100 as [Cloud Cover] ,

[humidity/value]/100 as [Humidity Value] ,

[pressure/value] as [Pressure Value] ,

[temperature/day] as [Temp Day] ,

[temperature/min] as [Temp Min] ,

[temperature/max] as [Temp Max] ,

[temperature/night] as [Temp Night] ,

[temperature/eve] as [Temp Evening] ,

[temperature/morn] as [Temp Morning] ,

[windSpeed/mps] as [Wind Speed mps] ,

[windSpeed/mps] * 2.23693629 as [Wind Speed mph] ,

[windSpeed/mps] * 3.6 as [Wind Speed kph] ,

Capitalize ( [windSpeed/name] ) as [Wind Speed Name] ,

[windDirection/deg] as [Wind Direction Deg] ,

[windDirection/code] as [Wind Direction Code] ,

Capitalize ( [windDirection/name] ) as [Wind Direction Name] ,

if ( LEN([precipitation/value]) = 0 , 0.00 , num([precipitation/value] )) as [Precipitation Value] ,

Capitalize ( [precipitation/type] ) as [Precipitation Type] ,

Capitalize ( [symbol/name] ) as [Symbol Name]

FROM $(vURL)

(XmlSimple, Table is [weatherdata/forecast/time]);

////////////////////////////////

WeatherData:

LOAD

ApplyMap ( 'IdMap' , [location/name] ) as id ,

time ( time(Mid([sun/rise],12,5)) ) as [Sun Rise],

time ( time(Mid([sun/set],12,5)) ) as [Sun Set],

date(Left([meta/lastupdate],10)) as [Date Updated] ,

timestamp ( date(Left([meta/lastupdate],10)) + time(Mid([meta/lastupdate],12,5)) ) as [Last Updated],

time([meta/calctime]) as [Calc Time] ,

timestamp ( date(Left([meta/nextupdate],10)) + time(Mid([meta/nextupdate],12,5)) ) as [Next Update],

[location/name] as [Location] ,

// [location/country] as [Country] ,

[location/location/altitude] as [Altitude] ,

[location/location/latitude] as [Latitude] ,

[location/location/longitude] as [Longitude]

FROM $(vURL)

(XmlSimple, Table is [weatherdata]);

////////////////////////////////

Openweathermap.org had loads of weather related data that is good for practising QlikView on.

Re: Need sample DataBase for preparing some Qlikview reports.

jaimeaguilar — Fri, 25 Jul 2014 16:03:30 GMT

Hi,

you can download a sample database(.mdb format) directly from access just type northwind sample in the search field (depending on the version of office you have option may be different) and you can download it to you computer.

regards