Storing QVD based on monthyear in Qliksense

[ajsjoshua]

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);

[sunny_talwar]

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]

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.

[sunny_talwar · Accepted solution]

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]

Dear Sunny,

Thank u so much.

Regards,

Joshua.