Assign Months to field values based on previous column header position

Sun, 23 Aug 2009 06:49:44 GMT

Hi everyone, I am new to Qlikview and this site. I am hoping someone can suggest how I can assign month names (i.e. "Jan--09") to field values. This data is coming in from a transposed Text file, where the field values in the "month" column correspond only to their previous column header position. The table only contains the most recent 24 months of data at any given time.

I can automatically extropolate the current DataMonth. And I know I can build on this using the "addmonths" function, but I'm not sure how to rename the fields using this information. Thank you, I appreciate any help you can offer.

Assign Months to field values based on previous column header position

Sun, 23 Aug 2009 12:07:05 GMT

J-rawk,

Welcome to the Community! We're glad to have you.

As far as your question goes, I'm not quite sure I understand, but I'll do my best to help (I'm only the Community Manager, all of the technical QV gurus must have a life on weekends )

It sounds like you have the function worked out, you just want to rename the field in the load script? Here's an example where I perform a function on a field called "Joined" and rename it "Weekday":


weekday(floor(Joined)) as Weekday,

Is that what you were looking for?

topic Assign Months to field values based on previous column header position in QlikView

Assign Months to field values based on previous column header position

Assign Months to field values based on previous column header position