Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

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
Luminary Alumni
Luminary Alumni

Hi,

Check this link

Partial Reload Easy and Simple

Regards,

Jagan.