Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be mock up data of your own liking using Mockaroo - Random Data Generator | CSV / JSON / SQL / Excel
You don't want to mock up your own data?
ya i dont..
Okay, I am sure somewhere might have data for you in that case
Your question is very Generic. What you mean by good data? Depends on what you looking for. Provide more info for better help.
Just generate something yourself using ctrl+q+q
Or look here:
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')
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 ..