Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ajsjoshua
Contributor III

Storing QVD based on monthyear in Qliksense

Dear all,

I am unable to store Qvd based on Yearmonth.

LET vYearmonthstore=Year(DATEOFTXN)&Month(DATEOFTXN);

STORE Bounce INTO [lib://QVD /Bounce_Live_$(vYearmonthstore).QVD] (qvd);

1 Solution

Accepted Solutions
MVP
MVP

Re: Storing QVD based on monthyear in Qliksense

May be try this

Fact:

LOAD ...,

     DATEOFTXN

FROM ....;


MonthYear:

LOAD Date(MonthStart(DATEOFTXN), 'YYYYMMM') as MonthYear

Resident Fact;


LET vYearmonthstore = Peek('MonthYear');

STORE Bounce INTO [lib://QVD /Bounce_Live_$(vYearmonthstore).QVD] (qvd);


4 Replies
MVP
MVP

Re: Storing QVD based on monthyear in Qliksense

Is this a field name?

DATEOFTXN

If it is, then you can't really use this directly in LET ... Can you let us know if DATEOFTXN has single value or multiple values?

ajsjoshua
Contributor III

Re: Storing QVD based on monthyear in Qliksense

Dear Sunny,

Yes DATEOFTXN is a fieldname and it has multiple values.

DATEOFTXN

2018-06-25 00:00:00:000000

2018-06-24 00:00:00:000000

2018-06-23 00:00:00:000000

Regards,

Joshua.

MVP
MVP

Re: Storing QVD based on monthyear in Qliksense

May be try this

Fact:

LOAD ...,

     DATEOFTXN

FROM ....;


MonthYear:

LOAD Date(MonthStart(DATEOFTXN), 'YYYYMMM') as MonthYear

Resident Fact;


LET vYearmonthstore = Peek('MonthYear');

STORE Bounce INTO [lib://QVD /Bounce_Live_$(vYearmonthstore).QVD] (qvd);


ajsjoshua
Contributor III

Re: Storing QVD based on monthyear in Qliksense

Dear Sunny,

Thank u so much.

Regards,

Joshua.

Community Browser