Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
prachi91
Creator III
Creator III

Preceding Load

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

10 Replies
swuehl
MVP
MVP

Maybe start with

Preceding Load

prachi91
Creator III
Creator III
Author

its very tough to understand for me

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
santiago_respane
Specialist
Specialist

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,

prachi91
Creator III
Creator III
Author

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.

prachi91
Creator III
Creator III
Author

Thank you Santiago Respane , really it is very helpful to me.

Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MayilVahanan

Hi


For your question,

tell me one thing in preceding load can we used load within load. - Yes, we can..



Thanks & Regards,
Mayil Vahanan R
prachi91
Creator III
Creator III
Author

Thank you guys

Best,

Prachi