I am new to the QV,
I have data in Excel Sheet;
I want to load statement when I am directly copy paste data from Excel Sheet,
I don’t want using FILE WIZARD, could you please help me.
You mean, when you copy paste the data in script editor it should automatically prepare load statement ?
you are looking for something like below
Load WeekNum, Month, Sales
I am looking like,
Sales FROM [auto number.xlsx] (ooxml, embedded labels, table is Sheet1);
As per my understanding, Qlikview will not prepare the Load statement when you copy/paste. May I know the reason why you want do like this?
By Using inline function you get it...
go to script menu
in insert tab---->load statement---->load inline--->there you paste your excel data and then ok..
wirte you field name replace F1 like
on double click F1 change it to WeekName as corresponding for all field name....
hope it helps you
Hi Mohit and KS,
Thanks for u'r time...
I have huge data and when i am using FILE WIZARD it will take more time.
And I am trying (Inline data Wizard) in insert tab---->load statement---->load inline--->
But, dimension name is missing.
Try something like this.
LOAD * INLINE [
WeekNum, Month, Sales
1, Jan, 75
2, Jan, 85
3, Jan, 60
4, Jan, 100
1, Feb, 120
2, Feb, 100
Seems not as possible but yes u can go to insert option on script window and then inline,
and now copy and pasete
Retrieving data ...