Data for dashboard

[Anonymous]

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

[sunny_talwar]

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

[Anonymous]

[sunny_talwar]

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

[Anonymous]

ya i dont..

[sunny_talwar]

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

[vishsaggi]

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

[adamdavi3s]

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

[shekhar_analyti]

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