Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Preceding Load in Qliksense

Dear All,

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

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Preceding Load in Qliksense

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.


5 Replies
MVP
MVP

Re: Preceding Load in Qliksense

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.


MVP
MVP

Re: Preceding Load in Qliksense

this is a good start for preceding load

Preceding Load

Not applicable

Re: Preceding Load in Qliksense

Hi Jagan,

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

Not applicable

Re: Preceding Load in Qliksense

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

MVP
MVP

Re: Preceding Load in Qliksense

Hi,

Check this link

Partial Reload Easy and Simple

Regards,

Jagan.

Community Browser