Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Preceding Load in Qliksense

Dear All,

I am new to Qliksense  how to perform the preceding load in qliksense?

1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

Hi,

Check below example for preceding load

Data:

LOAD                ///// Preceding Load, the TransactionDate field already formatted in initial load so there is no need to format in Month & Year fields.

*,

Month(TransactionDate) AS Month,

Year(TransactionDate) AS Year;

LOAD

TransactionID,

Date(Date#(TransactionDate, 'MMM-YYYY')) AS TransactionDate

FROM DataSource;


Check in Google or QV Community you will get n number of examples.


REgards,

Jagan.


View solution in original post

5 Replies
jagan
Partner - Champion III
Partner - Champion III

Hi,

Check below example for preceding load

Data:

LOAD                ///// Preceding Load, the TransactionDate field already formatted in initial load so there is no need to format in Month & Year fields.

*,

Month(TransactionDate) AS Month,

Year(TransactionDate) AS Year;

LOAD

TransactionID,

Date(Date#(TransactionDate, 'MMM-YYYY')) AS TransactionDate

FROM DataSource;


Check in Google or QV Community you will get n number of examples.


REgards,

Jagan.


maxgro
MVP
MVP

this is a good start for preceding load

Preceding Load

Not applicable
Author

Hi Jagan,

Thanks for your reply  by using ADD function how can perform the Partial reload in qlik sense

Not applicable
Author

Thanks for your reply  by using ADD function how can perform the Partial reload in qlik sense

jagan
Partner - Champion III
Partner - Champion III

Hi,

Check this link

Partial Reload Easy and Simple

Regards,

Jagan.