Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

derive period from date and column heading

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 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8
0102janfeb
ActualPlanActualPlanActualPlanActualPlan

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

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand
Highlighted
Specialist
Specialist

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.