derive period from date and column heading

[qlikhans]

Hi,

I have 2 files. File 1 is actual transactions in csv. File 2 is excel converted in QV to a crosstable.

File 1 has transaction dates dd-mm-yyyy.

File 2 has period numbers as column headers: 01, 02,03 etc.

when creating a pivot table in QV I get columns such as

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8
01		02		jan		feb
Actual	Plan	Actual	Plan	Actual	Plan	Actual	Plan

Where 01=jan and 02=feb

changing headings in excel to jan, feb etc does not solve my problem

who can help me to solve this issue?

krgrds Hans

Het bericht is bewerkt door: Hans kleijnen

[Gysbert_Wassenaar]

Can you describe what the issue is? What is the result you want to see? A qlikview document and example source files would be helpful.

[Anonymous]

I understand you want to convert your 01,02... month number field in text content. In this case try this:

Pick(num(yourmonthnumberfield),'jan','feb','mar','abr','may','jun','jul','aug','sep','oct','nov','dec')

Marc.