Extend incomplete month to 12 months

[uacg0009]

I don't know whether or not it is possible, just like the title said.

If I have some data and month is one of them. But for example, the month only has April, May, June, July and August.

And I want to make a list to show all 12 months, can I write some scripts to get that?

Thank you all!

[jagan]

Hi,

If you loading data from database using select, and for example you don't have YearStart() in SQL then we can use this, i.e., any qlikview transformation is required

Data:

LOAD

*,

YearStart(Date) AS YearStartDate,

Keepchar(String, '1234567890') As NewDim;

SELECT

*

FROM DataSource;

Hope this helps you.

Regards,

Jagan.