topic Re: Data for dashboard in QlikView

Data for dashboard

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello

I need good data for a dashboard creation so that i will used all functionality of qlikview in that dashboard.

so please share excel sheet of good data(at least 4 to 5 sheet).

Thank You..

Best

Prachi

Re: Data for dashboard

sunny_talwar — Thu, 09 Mar 2017 19:49:47 GMT

May be mock up data of your own liking using Mockaroo - Random Data Generator | CSV / JSON / SQL / Excel

Re: Data for dashboard

Anonymous — Thu, 09 Mar 2017 19:52:47 GMT

Re: Data for dashboard

sunny_talwar — Thu, 09 Mar 2017 19:55:39 GMT

You don't want to mock up your own data?

Re: Data for dashboard

Anonymous — Thu, 09 Mar 2017 19:59:35 GMT

ya i dont..

Re: Data for dashboard

sunny_talwar — Thu, 09 Mar 2017 20:01:14 GMT

Okay, I am sure somewhere might have data for you in that case

Re: Data for dashboard

vishsaggi — Thu, 09 Mar 2017 20:11:32 GMT

Your question is very Generic. What you mean by good data? Depends on what you looking for. Provide more info for better help.

Re: Data for dashboard

adamdavi3s — Fri, 10 Mar 2017 08:51:07 GMT

Just generate something yourself using ctrl+q+q

Or look here:

Sample data

Or use this which I generated from ctrl+q+q

Transactions:

Load

'1' as TransCounter,

TransLineID,

TransID,

mod(TransID,26)+1 as Num,

Pick(Ceil(5*Rand1),'A','B','C','D','E') as Department,

Pick(Ceil(6*Rand1),'0','1','2','3','4','5') as Status,

Pick(Ceil(2*Rand1),'0','1') as OverdueFlag,

makedate(Ceil(2017-(3*Rand())),Ceil(12*Rand()),Ceil(28*Rand())) as OrderDate,

date(if(100*rand() >5,makedate('2017',Ceil(12*Rand1),Ceil(28*Rand1)),null())) as ShippedDate,

money(round(RAND()*25000,0.01)) AS Value;

Load

Rand() as Rand1,

IterNo() as TransLineID,

RecNo() as TransID

Autogenerate 10000

While Rand()<=0.5 or IterNo()=1;

MasterCalendar:

Load

TempDate AS OrderDate,

week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month,

Day(TempDate) As Day,

'Q' & ceil(month(TempDate) / 3) AS Quarter,

Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,

WeekDay(TempDate) as WeekDay

;

//=== Generate a temp table of dates ===

LOAD

date(mindate + IterNo()) AS TempDate

,maxdate // Used in InYearToDate() above, but not kept

WHILE mindate + IterNo() <= maxdate;

//=== Get min/max dates from Field ===/

LOAD

min(FieldValue('OrderDate', recno()))-1 as mindate,

max(FieldValue('OrderDate', recno())) as maxdate

AUTOGENERATE FieldValueCount('OrderDate')

Re: Data for dashboard

shekhar_analyti — Fri, 10 Mar 2017 14:30:22 GMT

I will share a real time data with you from retail domain .

But do let me know if you want in QVD or Excel is ok for you ..