Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I am new to qlikview. i come to know the used of preceding load in qlikview. why,when and where we used it.
Thank you
Maybe start with
its very tough to understand for me
You may get number of Thread related the same and Videos too
I will explain clearly the use of Preceding Load
Load * Inline [
DateField, Sales
41231, 10
41234, 20
54322, 30
42342, 40
];
From This Date has Number format. this case we can do resident as well. But, the easy method to prove the Precedin load
Load DateField, Date(DateField,'DD-MMM-YYYY') as DateField1, Sales;
Load * Inline [
DateField, Sales
41231, 10
41234, 20
54322, 30
42342, 40
];
When ever, User need to convert that Number to Actual date then we can work on Preceding load. In future if some other use need to work on Number function then they will use DateField or else DateField1 as per there need.
And, I am adding one more point if you know Sql it act as Having Clause. So, Having Clause is used like Preceding load in qlikview. In fact, There is no function in Qlikview as in Having that is the reason they release Preceding Load to do the same function in Qlikview
Having Clause Syntax:
SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value;
HTH
Hi mate, the preceding load is a way to perform various operations to a block of data that are step dependant. Also it is a way to perform the sql HAVING clause. Also it is interpreted from bottom to top in qlikview.
You may have used preceding loads when loading data from database as follows:
MyTable:
LOAD *; //This load will run second
SQL SELECT f1,f2,f3,f4,f5 from MySqlTable; //This load will run first
Here you have an example of the having clause:
TotalData:
LOAD field1,
field2,
field3,
SUM(Amount1) as TotalField
RESIDENT Mytable;
This load will generate a new table with 3 fields and the sum of the amount1 field named TotalField.
If you wanted to filter this by only the ones that have the TotalField greater than 100 you would have to create another table via load statement:
TotalDataGreaterThan100:
NOCONCATENATE
LOAD * RESIDENT TotalData WHERE TotalField > 100;
or use preceding load and do it in one step as follows:
TotalDataGreaterThan100:
LOAD * WHERE TotalField > 100; //This load will run second
LOAD field1,
field2,
field3,
SUM(Amount1) as TotalField
RESIDENT Mytable; //This load will run first
Hope this helps.
Kind regards,
Thank you Anil for the explanation.it is very helpful to me.
tell me one thing in preceding load can we used load within load.
Thank you Santiago Respane , really it is very helpful to me.
We can't say with in the Load. but it should like above
Load Field1, Date(Field2) as Field2; //This is Preceding Load
Load * from Table; //This is Source where we initiate the Spreadsheet.
I hope you may clear as you expected then follow and do your job
Qlik Community Tip: Marking Replies as Correct or Helpful
Hi
For your question,
tell me one thing in preceding load can we used load within load. - Yes, we can..
Thank you guys
Best,
Prachi